'Is there any way to get the date time on the "you replied to this message on [xxx]"?

I am trying to do a email export from outlook to excel macro which includes the recipient, email subject and most importantly the date time of email reply. I have tried searching for the list of mail item properties.

Besides .LastModificationTime, I cant seem to find any property closer to the exact date time on the "you replied to this message on [xxx]"

vbaoutlook


Solution 1:[1]

You need PR_LAST_VERB_EXECUTION_TIME (DASL name is http://schemas.microsoft.com/mapi/proptag/0x10820040) MAPI property, it can be accessed using MailItem.PropertyAccessor.GetProperty.
Take a look at the message with OutlookSpy (I am its author) - click IMessage button to see the available properties.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Dmitry Streblechenko

Related Questions

How do I get the paragraph number of the currently selected paragraph in Microsoft Word into an AppleScript variable?

Retrieving custom property value from received mail using GetProperty (which was set using SetProperty in Outlook VBA)

VBA to copy a file from one directory to another

How to add icons to emails in Outllook?

I keep assigning a value to my variable but it stays empty

Check if a cell from a selected range is visible

Create table from data on a worksheet with specific name and add column

Using VBA to query a SQL Server table in Excel

How can I generate a "Social Golfer" matrix for worker seating arrangement?

How to stop scroll bar auto jump in vba

Delete a mailitem permanently in outlook

If IsEmpty then go to column A but in same row and extract that data

Fetch data from website table using vba

How can I use a for each loop on an array?

VBA - worksheet object is hidden