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

Hi, I wrote a macro to send out email using ActiveWorkbook.SendEmail method.
However, every time before the email is sent, there will be an Outlook
warning message pop up on screen to ask you if you want to send out this
message. I have to click "Yes" to proceed. And using
"Application.DisplayAlert=False" will not turn this warning message off (I
guess it's because this is not an Excel warning message). Anyone knows how
to write the VBA code in Excel to turn this Outlook warning message off??
Thanks!!!!!! Sarah