ActiveWorkbook.SendMail Security Warning

[Michael Rekas]

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

 

[Norman Jones]

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

 

[Michael Rekas]

Thanks Norman

Most useful.

Regards

Michael

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