MailItem object has no property for when a reply was sent

Status
Not open for further replies.
M

mmoore

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

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


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

> > >

> Am Thu, 10 Dec 2009 20:04:01 -0800 schrieb mmoore:
>
> > 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 " 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

> > >

> Am Thu, 10 Dec 2009 20:04:01 -0800 schrieb mmoore:
>
> > 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.

> .
>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
S UserProperties of MailItem object. Outlook VBA and Custom Forms 3
S How to get RFC822 format message from the MailItem object. Outlook VBA and Custom Forms 4
P MailItem.To Property with VBA not work Outlook VBA and Custom Forms 2
G Event when creating task from mailitem Outlook VBA and Custom Forms 2
A Run-time error '430' on certain emails when trying to set "Outlook.mailitem" as "ActiveExplorer.Selection.Item" Outlook VBA and Custom Forms 2
U Outbox Message Stuck after reading some MailItem Properties with VBA Outlook VBA and Custom Forms 1
oliv- Best practice for catching mailitem.events Outlook VBA and Custom Forms 0
oliv- How to select an mailitem in explorer with "show as conversation" Outlook VBA and Custom Forms 8
JorgeDario How to capture and save the text, when responding a MailItem? Outlook VBA and Custom Forms 3
JorgeDario how to check a MailItem has a digital signature (SMIME) with vba? Outlook VBA and Custom Forms 1
JorgeDario ¿What property of mailitem can be used like primary key? Outlook VBA and Custom Forms 6
S Outlook VBA rule script to process both MailItem and MeetingItem Using Outlook 0
B right click outlook objects in OL2010 acts on current inbox mailitem Using Outlook 6
C MailItem Find method doesn't work Using Outlook 0
C MailItem.SaveAs not working Outlook VBA and Custom Forms 10
G RE:The signature is also inserted if you touch the MailItem. Outlook VBA and Custom Forms 1
B Add signature to MailItem Outlook VBA and Custom Forms 3
C How can I create a new MailItem inside a user folder? Outlook VBA and Custom Forms 4
S Create a new Outlook MailItem in an Outlook folder(not a draft) Outlook VBA and Custom Forms 2
A How to get OOM MailItem Raw data Outlook VBA and Custom Forms 2
S Saved Property of MailItem is copied Outlook VBA and Custom Forms 1
S MailItem Find Method question Outlook VBA and Custom Forms 6
N Getting the attachments in MailItem Outlook VBA and Custom Forms 1
T How to get MailItem.Body without security warning in Outlook 2010 Outlook VBA and Custom Forms 2
S ->[O2007] Parsing each line of a MailItem HTMLBody? Outlook VBA and Custom Forms 2
T How to get Inspector or MailItem from wordEditor Outlook VBA and Custom Forms 6
A Select the position of an attached file in a HTML mailitem Outlook VBA and Custom Forms 1
B Insert information to MailItem Outlook VBA and Custom Forms 1
E Properties added to MailItem in ItemSend event visible to recipien Outlook VBA and Custom Forms 1
V Setting HTMLBody of new mailItem Outlook VBA and Custom Forms 1
V How to find mailitem in the inspector is a brand new one Outlook VBA and Custom Forms 2
M Activate "Add digital signature to this massage" on a MailItem? Outlook VBA and Custom Forms 1
K importing EML in MailItem Outlook VBA and Custom Forms 1
A mailitem Send issue Outlook VBA and Custom Forms 5
M Get email address from MailItem.To? Outlook VBA and Custom Forms 6
R How to capture a Mailitem Event Outlook VBA and Custom Forms 3
S get current position in message body of mailitem Outlook VBA and Custom Forms 8
J Toolbar button to process current mailitem Outlook VBA and Custom Forms 1
D MailItem from an RSS feed Outlook VBA and Custom Forms 2
J Outlook 2007 crashed when pushing send on a displayed mailitem Outlook VBA and Custom Forms 1
N Memory with MailItem.Send Outlook VBA and Custom Forms 1
P Adding a button in a mailitem Outlook VBA and Custom Forms 1
S Reading mailitem after mail is send give runtime error. Outlook VBA and Custom Forms 1
D Max. length of MSO MailItem.EntryID Outlook VBA and Custom Forms 6
R MailItem.Display() error Outlook VBA and Custom Forms 1
R Clone mailitem Outlook VBA and Custom Forms 5
R MailItem Outlook VBA and Custom Forms 2
D Length of the MailItem.EntryID Outlook VBA and Custom Forms 2
M What is the recommendet way to read/write a user defined Field (Named Property) in the MailItem Obje Outlook VBA and Custom Forms 1
M What is the recommendet way to read/write a user defined Field (Named Property) in the MailItem Obje Outlook VBA and Custom Forms 5

Similar threads

Back
Top