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

Sarah,

Take a look at http://www.rondebruin.nl/mail/prevent.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sarah" wrote in message
...
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

Thanks a lot, Bob!!!!!!!!! Sarah

"Bob Phillips" wrote:

Sarah,

Take a look at http://www.rondebruin.nl/mail/prevent.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sarah" wrote in message
...
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