VBA in Excel to Email File

[jk9533]

I get the following message box from Outlook.
"A program is trying to automatically send e-mail on your behalf.
Do you want to allow this?"

The answer is yes but is there a way to stop this prompt from showing and
always be Yes?

 

[Michael Bauer [MVP - Outlook]]

If possible, move the code from Excel to Outlook, or use the Redemption
(www.dimastr.com); or don't call Send but Display, and then press the Send
button manually.

Here you can read everything subject to the security:
http://outlookcode.com/article.aspx?id=52

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Thu, 15 Jan 2009 15:04:01 -0800 schrieb jk9533:

 

[John Blessing]

If possible, move the code from Excel to Outlook, or use the
Redemption (www.dimastr.com); or don't call Send but Display, and
then press the Send button manually.

Here you can read everything subject to the security:
http://outlookcode.com/article.aspx?id=52

Another option is a little program called "clickyes" (google for it), which
will automatically click the Yes button for you.

Some say it is a security risk, but it is a looonng time since any
virus/worm was so unsophisticated as to try and access your Outlook files in
order to propagate, and a good antivirus package does a far better job than
MS's clunky 'fix'

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software
http://www.room-booking-software.com - Schedule rooms & equipment
bookings http://www.lbetoolbox.com - De-Duplicates MS Outlook
http://www.repeatmail.com - schedule mass individual emails