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.

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.