View Single Post
  #2  
Old February 10th 08, 09:13 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default 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.

Ads