VBA for Outlook
Posted on 2002-03-19
For every message in my Outlook "XYZ" folder of incoming items, I want to collect the following information:
a) date sent
b) E-mail address
c) Subject Line
d) Icon (replied, forwarded or nothing)
if (d) is replied or forwarded, then I would like to find the reply in my Sent Items folder and capture
e) date of reply/forward
f) text of reply/forward
g) time spent editing reply/forward would be a huge plus
The output would go to Access or Excel or a text file or whatever. I can handle writing the output.
I explored around the Outlook object model today, but couldn't even manage to loop through each mailitem in the CurrentFolder. I really got stopped when trying to find the replies - didn't seem to be any property even remotely related to that.
No need for complete answers - even if you have some piece of this answer, that would be great.