Thread: Mail shot
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Mail shot

I don't believe you can turn it off. However, Ron de Bruin has shows how to
use CDO to send the mail and avoid the message:

Ron de Bruin's site

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

--
Regards,
Tom Ogilvy

"Peter Bircher" wrote in message
...
Hi all

I wrote a program that uses the command .send to email several people. The
program has to run unattended as the mail is a warning if a certain piece of
eqiuipment fails respond.

Now when the program runs it requires user-intervention after a 5 second
wait. This is the help:

"A program is trying to send mail using Item.Send
A program is trying to automatically send e-mail using a Microsoft Outlook
Visual Basic Application command, Item.Send. If you want this program to
send this e-mail, click Yes. To stop the program, click No. If you are
unsure which program is sending the e-mail or why, you may want to click No
to avoid any possible spread of viruses.
Note When this message is displayed, the Yes button is not available for 5
seconds."
How can one turn off the security "feature" so that it will continue to send
automatically?
Thanks, in anticipation,
Peter