A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Identify unreplied emails in inbox



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old January 9th 09, 09:58 AM posted to microsoft.public.outlook.program_vba
Tausif
external usenet poster
 
Posts: 6
Default Identify unreplied emails in inbox

Hi Experts,

I need to keep a track of emails that have not been replied between a
specified date.

eg) Save a copy of emails in drafts folder from the outlook inbox between
the dates "01-Jan-09" & "07-Jan-2009" which have not been replied.

Any suggestions on this ?

Many Thanks,
--
Tausif Mohammed
Ads
  #2  
Old January 9th 09, 02:22 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default Identify unreplied emails in inbox

The Outlook object model doesn't explicitly expose property you'd need for
that. If you are using Outlook 2007 you could use the
MailItem.PropertyAccessor object to look at that property using a MAPI
property tag, otherwise you'd need to use a lower level API that allows
access such as CDO 1.21 or Redemption (www.dimastr.com/redemption).

What you'd need to look at is the PR_LAST_VERB_EXECUTED flag property.
That's a 32-bit Long (PT_LONG) where a value of 103 (EXCHIVERB_REPLYTOALL)
means ReplyAll and 102 (EXCHIVERB_REPLYTOSENDER) is Reply.

If that property isn't there then the item is there but never replied to or
forwarded.

For PropertyAccessor you'd use this DASL property tag string to get at
PR_LAST_VERB_EXECUTED (this is a tag, not an URL):
"http://schemas.microsoft.com/mapi/proptag/0x10810003"

For when it was replied to (another property that won't be there if no
reply/forward) you would use PR_LAST_VERB_EXECUTION_TIME
("http://schemas.microsoft.com/mapi/proptag/0x10820040"). Reading that
property if it's there gives you the time in UTC.

For Redemption you can use an RDOMail item's Fields property and the DASL
tags to access those properties, again they'd be Empty or null if not there.

For CDO 1.21 code see the topic "Set the Outlook Reply/Forward Flag" at
http://www.cdolive.com/cdo5p2.htm for a look at code that plays with
reply/replyall/forward.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Tausif" wrote in message
...
Hi Experts,

I need to keep a track of emails that have not been replied between a
specified date.

eg) Save a copy of emails in drafts folder from the outlook inbox between
the dates "01-Jan-09" & "07-Jan-2009" which have not been replied.

Any suggestions on this ?

Many Thanks,
--
Tausif Mohammed


  #3  
Old January 9th 09, 03:18 PM posted to microsoft.public.outlook.program_vba
Tausif
external usenet poster
 
Posts: 6
Default Identify unreplied emails in inbox

Thank You for pointing me in some direction. I will look into this.
Rgds,
--
Tausif Mohammed


"Ken Slovak - [MVP - Outlook]" wrote:

The Outlook object model doesn't explicitly expose property you'd need for
that. If you are using Outlook 2007 you could use the
MailItem.PropertyAccessor object to look at that property using a MAPI
property tag, otherwise you'd need to use a lower level API that allows
access such as CDO 1.21 or Redemption (www.dimastr.com/redemption).

What you'd need to look at is the PR_LAST_VERB_EXECUTED flag property.
That's a 32-bit Long (PT_LONG) where a value of 103 (EXCHIVERB_REPLYTOALL)
means ReplyAll and 102 (EXCHIVERB_REPLYTOSENDER) is Reply.

If that property isn't there then the item is there but never replied to or
forwarded.

For PropertyAccessor you'd use this DASL property tag string to get at
PR_LAST_VERB_EXECUTED (this is a tag, not an URL):
"http://schemas.microsoft.com/mapi/proptag/0x10810003"

For when it was replied to (another property that won't be there if no
reply/forward) you would use PR_LAST_VERB_EXECUTION_TIME
("http://schemas.microsoft.com/mapi/proptag/0x10820040"). Reading that
property if it's there gives you the time in UTC.

For Redemption you can use an RDOMail item's Fields property and the DASL
tags to access those properties, again they'd be Empty or null if not there.

For CDO 1.21 code see the topic "Set the Outlook Reply/Forward Flag" at
http://www.cdolive.com/cdo5p2.htm for a look at code that plays with
reply/replyall/forward.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Tausif" wrote in message
...
Hi Experts,

I need to keep a track of emails that have not been replied between a
specified date.

eg) Save a copy of emails in drafts folder from the outlook inbox between
the dates "01-Jan-09" & "07-Jan-2009" which have not been replied.

Any suggestions on this ?

Many Thanks,
--
Tausif Mohammed



 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
unreplied mails in Outlook-2007 Vaibhav Outlook and VBA 1 October 18th 08 04:27 PM
Help me identify the symbols in "Icon" field of my Inbox in Outloo [email protected] Outlook - General Queries 5 May 24th 08 11:58 AM
emails in inbox warren Outlook Express 4 February 23rd 07 04:17 PM
emails message icon are receiving but no emails in the inbox Mei Outlook Express 5 October 31st 06 02:14 AM
tracking unreplied messages [email protected] Add-ins for Outlook 3 July 6th 06 11:10 PM


All times are GMT +1. The time now is 01:09 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2024 Outlook Banter.
The comments are property of their posters.