Programmatically setting a MailItem's followup flag to complete?

vba outlook outlook-2007
MidnightThoughtful picture MidnightThoughtful · Dec 11, 2010 · Viewed 13.4k times · Source

I'm trying to find out how to set a MailItem's followup flag to completed via VBA in Outlook 2007?

Googling returns a lot of hits for methods that were valid in Outlook 2003 and before (for example, changing the value of the MailItem's FlagStatus property, as is demonstrated in Outlook 2007 - Email Flag Status), however Microsoft overhauled flagging for OL 2007 and the FlagStatus property is no longer available in OL2007 (despite what is implied by the link above).

Does anyone know how to set the currently selected MailItem's follow-up status to completed in OL2007 VBA?

Any advice or working code would be appreciated!

planetthoughtful

Answer

Fionnuala picture Fionnuala · Dec 12, 2010

How about:

''Case sensitive
If oItem.FlagRequest = "Follow up" Then
    oItem.FlagStatus = olFlagComplete
End If

http://msdn.microsoft.com/en-us/library/aa212007(office.11).aspx
http://msdn.microsoft.com/en-us/library/aa212013(office.11).aspx

Outlook 2010 Help, my highlight

MailItem.FlagRequest Property
Returns or sets a String that indicates the requested action for a mail item.
Read/write. Version Information
Version Added: Outlook 2007

Syntax

expression.FlagRequest

Related questions

Regular Expression Rules in Outlook 2007?

Is it possible to create rules in Outlook 2007 based on a regex string? I'm trying to add a filter for messages containing a string such as: 4000-10, a four digit number followed by a dash and then a two digit …

Read More
Copy email to the clipboard with Outlook VBA

How do I copy an email to the clipboard and then paste it into excel with the tables intact? I am using Outlook 2007 and I want to do the equivalent of "Click on email > Select All > Copy > …

Read More
Move emails to a different data/PST file

I have edited a script I found online to move email to various folders. I want to take it a step further to move emails to a folder within a separate PST file. This will be running in Outlook 2007. The …

Read More