Outlook vba macro

Status
Not open for further replies.

bevg1971

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
I am looking for a macro that will pop up a warning message for any email message that has been in the inbox for 20 working hours (regardless if the message has been opened or not). measuring from the received time to now().

i have done some many searches and i am not getting anywhere, can you please help me or guide me i can get guidance. i know a little bit of vba.

thanks,

Byron
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
The problem is that outlook vba doesn't include a timer, so you can't 'watch' messages. But you can do it, although not necessarily exactly after 20 hours. The easiest is with a macro that is triggered by a reminder. Or you can use auto-mate - this is an outlook rules addin that runs rules later. http://www.pergenex.com/auto-mate/index.shtml

Or you could use a run--script rule to set reminders on messages as they arrive and click on them to mark them complete as you read or act on them.

Start with http://www.slipstick.com/outlook/rules/create-rule-to-expire-mail-after-a-number-of-days/ - instead of expiring messages, you'll set a flag and a reminder.

With item

' due this week flag
.MarkAsTask olMarkThisWeek

' sets a specific due date
.TaskDueDate = Now + .83 ' not exactly 20 hours
.ReminderSet = True
.ReminderTime = Now + .83
.Save

End With
 
Status
Not open for further replies.
Top