Track e-mail response time
 

Hi,
I'd like to create a macro I can run that would check all e-mails in a
certain folder that multiple users have access to: "Completed" and compile a
report that would show the subject line, the sender, the initail time/date
recieved, and the time/date replied to.
I'm thinking that it would be best if this macro could take control of Excel
to generate this report, but I'm looking for any ideas.

Track e-mail response time
 

With CDO 1.21 or Redemption (www.dimastr.com) you can read an item's
PR_LAST_VERB_EXECUTION_TIME property. That tells you the time of the very
last action (reply, forward). The first one (if there are more) is not
tracked.

--
Best regards
Michael Bauer - MVP Outlook
Use Outlook Categories? This is Your Tool:
http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6

Am Sat, 9 Feb 2008 10:09:01 -0800 schrieb VBA007:

Hi,
I'd like to create a macro I can run that would check all e-mails in a
certain folder that multiple users have access to: "Completed" and compile
a
report that would show the subject line, the sender, the initail time/date
recieved, and the time/date replied to.
I'm thinking that it would be best if this macro could take control of
Excel
to generate this report, but I'm looking for any ideas.