Thread: sendmail error
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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