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.

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.

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.
.

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.
.