Microsoft Excel
Back to jkp-ads.com

Ron de Bruin
Excel Automation

Microsoft MVP Program

Disable the mail security dialog to Send/not Send the mail

Important message to visitors of this page

Ron de Bruin decided to remove all Windows Excel content from his website for personal reasons. If you want to know why, head over to rondebruin.nl.

Luckily, Ron was kind enough to allow me to publish all of his Excel content here.

Most of these pages are slightly outdated and may contain links that don 't work. Please inform me if you find such an error and I'll try to fix it.

Kind regards

Jan Karel Pieterse


When you use the code examples from my mail page it is possible you get this security warning

Outlook Express and Windows Mail

If you use Outlook Express or Windows Mail as your default mail program you can turn off
this warning when you use the SendMail examples on my site.

1: Start Outlook Express or Windows Mail, and then on the Tools menu, click Options.
2: Click the Security tab, and then click to remove the check mark from the
    "Warn me when other applications try to send mail as me" check box.
3: Click OK to close the Options dialog box.

 

Outlook object model examples

If you use Outlook 2007 or up you not see this warning with a correct installed system with a virusscanner that Microsoft thinks is OK. Read the info on the following page :
http://msdn.microsoft.com/en-us/library/ms778202.aspx

But if you use Outlook 2000-2003 you must use a third party program to avoid the warning.

Express ClickYes
http://www.contextmagic.com/express-clickyes/

Outlook Redemption
http://www.dimastr.com/redemption/

Or try to use this SendKeys example if you use one of the Outlook object model examples
from my mail page. Instead of .Send in the code examples you can use this three lines.

.Display
Application.Wait (Now + TimeValue("0:00:02"))
Application.SendKeys "%s"


Note: SendKeys is not always reliable and this will not work on every computer.
The S is from Send, if you not use a English version you must change this letter.
This tip is only working for the Outlook object model examples on my site.

 

Mail with CDO

Another option is to check out this page and see if CDO is working on your machine. There are no security warnings when you use CDO to send mail.

Sending mail from Excel with CDO