ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Mail shot (https://www.excelbanter.com/excel-programming/307837-mail-shot.html)

Peter Bircher

Mail shot
 
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


Tom Ogilvy

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



Peter Bircher

Mail shot
 
Thanks, Tom, I will have a look.

"Progress" always comes at a price.

Peter

"Tom Ogilvy" wrote in message
...
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






All times are GMT +1. The time now is 04:25 PM.

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