In MS Outlook, report all sent-messages that haven

问题:

I send out a lot of emails each day and often fail to keep track of which ones actually get replied to.

Is there a way I can use a VBA script to look at say all the sent messages in the last week, and check if they received replies?

Specifically, a report of the sent email messages that have NOT yet received replies to them from at least one of the addresses they were sent to.

I know a little bit of Excel VBA but I don't know where to start with this one... or if it's even possible.

Ideas?

[Asking for a friend, personally I despise Outlook]

回答1:

As Jez suggested, look at the message id of the sent message (you can access it using MailItem.PropertyAccessor), you can then try to find the matching message in your inbox folder by reading the PR_TRANSPORT_MESSAGE_HEADERS property (again, use MailItem.PropertyAccessor, the property will contain the MIME headers from the main MIME part of the message) and extracting the "In-Reply-To" and "References" headers.
You can see the relevant properties along with their property tags and DASL names in OutlookSpy (click IMessage button).

回答2:

i know you can track whether it was read / received. follow this tutorial, or a different for your outlook version

http://office.microsoft.com/en-us/outlook-help/get-delivery-and-read-receipt-confirmations-HP010080428.aspx#BM1