View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default ActiveWorkbook.SendMail Security Warning

Hi Michael,

See Ron de Bruins SendMail pages at:

http://www.rondebruin.nl/sendmail.htm

See particularly:

http://www.rondebruin.nl/mail/prevent.htm

and the "Why using CDO code instead of Outlook automation or
Application.SendMail in VBA." section at:

http://www.rondebruin.nl/cdo.htm


---
Regards,
Norman



"Michael Rekas" wrote in message
...
Hi there

When using the code ActiveWorkbook.SendMail... a security warning "A
program is trying to automatically send e-mail on your behalf. Do you
want to allow this?" appears.

Can one add code to suppress this message?

Thanks

Michael