MS Outlook-tracking mails

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
CIPL-SenthilAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David LeeCommented:
What's your goal for this?  What information are you looking to collect?
0
CIPL-SenthilAuthor Commented:
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
David LeeCommented:
Would this be for one computer or for a group of computers?  if the latter, how many?
0
CIPL-SenthilAuthor Commented:
I am looking for a standalone application.
0
David LeeCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Outlook

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.