Thread: Check whether Follow Up set
View Single Post
 
Old 10-27-2010, 11:19 PM
konfis konfis is offline Windows XP Office 2007
Novice
  
Join Date: Oct 2010
Posts: 1
konfis is on a distinguished road
Default Check whether Follow Up set
Hey People,

i am trying to use my Excel VBA skills in Outlook, but its not working well yet.

The Problem:
During the design of the mail the follow up flag is set. When the mail is sent the ItemSend Event is triggered and the code is executed. Within this code it should be checked the follow up flag is set, but I cant figure out how to do that. I tried it with the following code:

Code:
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) 

      Set myOlApp = CreateObject("Outlook.Application") 
       Set objNS = myOlApp.GetNamespace("MAPI") 
       Set MyFolder = objNS.GetDefaultFolder(6) 
       
      If Item.FlagRequest = "Follow up" Then MsgBox "Flagged" 
             
 Sub
I already tried to investigate the Item.Flagstatus but always get a retun value of 0, independet whether the follow up is set or not.

Anybody an idea how to check whether the Follow up flag is set?

Thanks
Moritz
Reply With Quote