#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
May be a long-shot, but..... [email protected] Excel Worksheet Functions 3 July 4th 08 01:03 PM
Shot down with blanks Dave Excel Worksheet Functions 5 April 9th 08 12:21 PM
O/T I know this may get me shot.......... gsmcellular Excel Discussion (Misc queries) 7 July 10th 06 06:08 PM
inserting multiple rows in one shot? Greg Excel Discussion (Misc queries) 3 June 28th 06 07:26 PM
A shot in the dark Rodney New Users to Excel 12 May 27th 05 01:48 AM


All times are GMT +1. The time now is 01:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"