Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
May be a long-shot, but..... | Excel Worksheet Functions | |||
Shot down with blanks | Excel Worksheet Functions | |||
O/T I know this may get me shot.......... | Excel Discussion (Misc queries) | |||
inserting multiple rows in one shot? | Excel Discussion (Misc queries) | |||
A shot in the dark | New Users to Excel |