Solved

MS Outlook-tracking mails

Posted on 2007-03-21
7
180 Views
Last Modified: 2010-04-08
Hi experts,

I would like to track the mails received and the mails replied in MS Outlook. Can you suggest me a solution for this.

Regards
Vijay T. Prabakar
0
Comment
Question by:CIPL-Senthil
  • 3
  • 2
7 Comments
 
LVL 76

Expert Comment

by:David Lee
ID: 18770003
What's your goal for this?  What information are you looking to collect?
0
 

Author Comment

by:CIPL-Senthil
ID: 18770376
I would like to have a report of the mails received and responded using REPLY button in MS Outlook. I would like to automate this using VBA.
0
 
LVL 76

Expert Comment

by:David Lee
ID: 18771923
Would this be for one computer or for a group of computers?  if the latter, how many?
0
 

Author Comment

by:CIPL-Senthil
ID: 18777487
I am looking for a standalone application.
0
 
LVL 76

Accepted Solution

by:
David Lee earned 500 total points
ID: 18789718
Keeping track of the messages received is simple.  Keeping track of responses is a lot more difficult, assuming that by responses you mean a reply to a received item.  There simply is no definitive way to know if an item has been replied to or if an item is a reply.  If you look at an item you've replied to you do see the text "You replied on ..." at the top of the message.  Unfortunately, that is not reliable.  Open an item you've received and click Reply.  Cancel the reply.  Now, re-open the original message and you'll still see the "You replied on ..." entry at the top.  Nor does an Outlook reply maintain an explicit link to the item being replied to.  It does maintain a conversation index that ties all the messages in a given converstaion together, but I think it'd be difficult to use that to determine that an item is a reply.  I thought about trapping an object's Reply event, but that would suffer from the same problem that the "You replied on ..." mechanism does.  Clicking Reply would write an entry into the log file showing that you'd replied, yet you might have cancelled the reply before sending.  The only sure way of doing this would require creating a custom form.  In the custom form you'd trap the Reply event and set a user property to indicate that the message is a reply.  You'd then be able to key on that property when the item is sent and write a log entry if the item is a reply.  But, there are problems with this too.  It's unlikely that the folks sending messages to you would be using that custom form.  This would require you to convert all received messages to use your custom form.  In short, there is no good way of doign this that I can think of.  If instead you'd like to log all messages sent, which would include replies, but wouldn't be limited to them, then that's easy.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Sometimes Outlook might have problems sending a message. There may be various causes- corrupted PST, AV scanner etc. The message, instead of going to the Sent Items folder, sits in the Outbox indefinitely. To remove it you can use a free tool cal…
If you don't know how to downgrade, my instructions below should be helpful.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now