ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   sendmail error (https://www.excelbanter.com/excel-programming/304746-sendmail-error.html)

marta

sendmail error
 
Hi,
I am using the SendMail action in my macro, when it runs I
get the following Outlook message:

"A program is trying to automatically send e-mail on your
behalf. Do you want to allow this?
If this is unexpected, it may be a virus and you should
choose "No"."

Here's my code:

ActiveWorkbook.SendMail Recipients:=Array
("recipient1", "recipient2")

Is there any way to by-pass this dialog box?

Thanks,
Marta

Ron de Bruin

sendmail error
 
Hi marta

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"marta" wrote in message ...
Hi,
I am using the SendMail action in my macro, when it runs I
get the following Outlook message:

"A program is trying to automatically send e-mail on your
behalf. Do you want to allow this?
If this is unexpected, it may be a virus and you should
choose "No"."

Here's my code:

ActiveWorkbook.SendMail Recipients:=Array
("recipient1", "recipient2")

Is there any way to by-pass this dialog box?

Thanks,
Marta





All times are GMT +1. The time now is 02:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com