MailItem object has no property for when a reply was sent
 

After replying to a message, new text appears at the top of the original
message: "You replied on 12/8/2009 9:02 PM."

In VBA, how do I detect if a mail item has been replied to?

I've looked at the properties for the MailItem object.
One of the MailItem properties is ItemProperties. I iterated through it.
I can't find any property with this info.

My goal is to automate finding duplicate mail items.

Many items got duplicated by accident. I thought I'd just look for items
with the same subject, received time & a couple other attributes. Then delete
all but one copy. It should be easy....

Well, I delayed in cleaning up the duplicates. I've replied to some of them.
In Outlook, only the particular one I replied to shows "you replied..." at
the top. I want to keep the item that has this "you replied..." text and
delete all other copies.

MailItem object has no property for when a reply was sent
 

Since OL07 you can use the ProeprtyAccessor for that, in older version use
CDO 1.21 or Redemption (www.dimastr.com).

Look for the property PR_LAST_VERB_EXECUTION_TIME, which has the PropTag
0x10820040, or in DASL: http://schemas.microsoft.com/mapi/proptag/0x10820040

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Thu, 10 Dec 2009 20:04:01 -0800 schrieb mmoo

After replying to a message, new text appears at the top of the original
message: "You replied on 12/8/2009 9:02 PM."

In VBA, how do I detect if a mail item has been replied to?

I've looked at the properties for the MailItem object.
One of the MailItem properties is ItemProperties. I iterated through it.
I can't find any property with this info.

My goal is to automate finding duplicate mail items.

Many items got duplicated by accident. I thought I'd just look for items
with the same subject, received time & a couple other attributes. Then
delete
all but one copy. It should be easy....

Well, I delayed in cleaning up the duplicates. I've replied to some of
them.
In Outlook, only the particular one I replied to shows "you replied..." at
the top. I want to keep the item that has this "you replied..." text and
delete all other copies.

MailItem object has no property for when a reply was sent
 

Hi Michael,

Thanks for your answer & quick reply, but it didn't give me what I want.

Apparently, some other verb has been executed since the last reply. I tried
to use PR_LAST_VERB_EXECUTED to determine which verb, but it didn't work.

MSDN library gives
0x1082 PR_LAST_VERB_EXECUTION
0x1081 PR_LAST_VERB_EXECUTED

That's different than your value 0x10820040.
Your value works & the ones from MSDN do not.

I spent a couple hours looking though the MSDN libary for something like
PR_LAST_REPLY_TIME or PidTagLastReplyTime. I didn't find anything.

Can you find the property?

Thank you, Mike

--------------
"Michael Bauer [MVP - Outlook]" wrote:



Since OL07 you can use the ProeprtyAccessor for that, in older version use
CDO 1.21 or Redemption (www.dimastr.com).

Look for the property PR_LAST_VERB_EXECUTION_TIME, which has the PropTag
0x10820040, or in DASL: http://schemas.microsoft.com/mapi/proptag/0x10820040

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Thu, 10 Dec 2009 20:04:01 -0800 schrieb mmoo

After replying to a message, new text appears at the top of the original
message: "You replied on 12/8/2009 9:02 PM."

In VBA, how do I detect if a mail item has been replied to?

I've looked at the properties for the MailItem object.
One of the MailItem properties is ItemProperties. I iterated through it.
I can't find any property with this info.

My goal is to automate finding duplicate mail items.

Many items got duplicated by accident. I thought I'd just look for items
with the same subject, received time & a couple other attributes. Then
delete
all but one copy. It should be easy....

Well, I delayed in cleaning up the duplicates. I've replied to some of
them.
In Outlook, only the particular one I replied to shows "you replied..." at
the top. I want to keep the item that has this "you replied..." text and
delete all other copies.
.

MailItem object has no property for when a reply was sent
 

Hi Michael,

I finally understand. I installed OutlookSpy & saw that the last verb was
reply to sender. Then I noticed that the time shown in the property isn't
entirely different. It's different by exactly 8 hours. My time zone is 8
hours off GMT.

Problem solved. Thanks for your help.

Thank you, Mike

-----------------
"Michael Bauer [MVP - Outlook]" wrote:



Since OL07 you can use the ProeprtyAccessor for that, in older version use
CDO 1.21 or Redemption (www.dimastr.com).

Look for the property PR_LAST_VERB_EXECUTION_TIME, which has the PropTag
0x10820040, or in DASL: http://schemas.microsoft.com/mapi/proptag/0x10820040

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Thu, 10 Dec 2009 20:04:01 -0800 schrieb mmoo

After replying to a message, new text appears at the top of the original
message: "You replied on 12/8/2009 9:02 PM."

In VBA, how do I detect if a mail item has been replied to?

I've looked at the properties for the MailItem object.
One of the MailItem properties is ItemProperties. I iterated through it.
I can't find any property with this info.

My goal is to automate finding duplicate mail items.

Many items got duplicated by accident. I thought I'd just look for items
with the same subject, received time & a couple other attributes. Then
delete
all but one copy. It should be easy....

Well, I delayed in cleaning up the duplicates. I've replied to some of
them.
In Outlook, only the particular one I replied to shows "you replied..." at
the top. I want to keep the item that has this "you replied..." text and
delete all other copies.
.