Calculate Average Response Time of Emails

[Martin Los]

I want to calculate the avergae response time of my emails.

How?

1. Check mailbox where email was received (INBOX):
a. Determine unique number to identify email
(objMailItem.EntryID)
b. Determine time e-mail was received (accessing the
property "objMailItem.ReceivedTime").

2. Check mailbox where answered email is stored (OUTBOX):
a. Goto item (looking for objMailItem with EntryID = 1a)
b. Determine the time the e-mail was answered (accessing
the property "objMailItem.SentOn").

Calculate response time as 2b - 2a.

Any ideas about VBA code?

TIA

Martin

 

[Dmitry Streblechenko \(MVP\)]

Won't work - entry ids will be different for messages in different folders.
You can either:
1. Read PR_CONVERSATION_INDEX property and find an e-mail in the Sent Items
folder with the same value of PR_CONVERSATION_INDEX plus 5 bytes (see MSDN
for how PR_CONVERSATION_INDEX is created)
2. Read PR_MESSAGE_DELIVERY_TIME and PR_LAST_VERB_EXECUTION_TIME
(0x10820040). PR_LAST_VERB_EXECUTION_TIME is what Outlook uses when it
displays "You replied on..." or "You forwarded this message on ...".

Both PR_CONVERSATION_INDEX and PR_LAST_VERB_EXECUTION_TIME can be accessed
using Extended MAPI, CDO 1.21 or Redemption, but not Outlook Object Model.

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool