Solved

MS Outlook-tracking mails

Posted on 2007-03-21
7
187 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Find out what you should include to make the best professional email signature for your organization.
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
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 …

691 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