View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harvey[_4_] Harvey[_4_] is offline
external usenet poster
 
Posts: 2
Default Disable Warning Message from Microsoft Outlook in Excel VBA

you can use the sendkeys command to send a the hotkey y to outlook.
This has the same effect as when you click yes, only the macro does it
for you this time. You have to wait 5 seconds before using te sendkey
command in order for it to work (outlook waits 5 seconds before
enabling the yes button)