Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-27-2010, 11:19 PM
konfis konfis is offline Check whether Follow Up set Windows XP Check whether Follow Up set Office 2007
Novice
Check whether Follow Up set
 
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I print out the document as follow? turbomen Project 1 05-23-2010 07:24 AM
Check whether Follow Up set create letter template with fixed position fields and follow up pages Lynn O'Shea Word 3 05-18-2010 12:32 AM
Need Help with Using a Check Box Nick9589 Excel 1 05-01-2010 09:29 AM
auto follow link magni PowerPoint 0 01-28-2010 12:48 AM
Check Box in Word serayam Word 1 11-06-2008 06:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft