Send Email (box that pops up to allow emails to be sent)

I was wondering if there is a way to get rid of this?? There are about 300 emails that are going to be sent out and this comes up every time.

Or if there is a way to only do it once no matter how many emails get sent.


Here is part of the code..

Please Login or Register  to view this content.

I have added a picture of the the box that pops up.


Thanks, J

Hello Slomaro2000,

Yes you can, if you are sending the emails from your computer. I am working on a tutorial document on how to do this. There are quite a few steps involved. Microsoft doesn't make it easy. I will post it here when I finish it, probably by tomorrow. If that doesn't work for you then maybe I could give you a crash course on how to do it.

Hello Slomaro2000,

Outlook will only dismiss the security messages if the macro is from a trusted source. The only way to make a macro "trusted" is digitally sign it. You have 2 choices: use SelfCert or purchase a signature from a third party like VeraSign. You might consider the latter if this for a business network, but not for personal use due to cost.

I use the express clickYes download that Ron has on his website

http://www.rondebruin.nl/mail/prevent.htm

VBA Noob

Or just use CDO:

http://www.rondebruin.nl/cdo.htm

Hello Slomaro2000,

Thanks for the reminder. I should have it finished today. It's a Word document with pictures of the dialog boxes on the screen. Makes it easier to follow and a little longer to write up, but worth it.

Hello Slomaro2000,

Finished the tutorial! I have attached it to this post. It is a Word 2003 document. If something isn't clear to you, let me know.

Hello Jayson,

The tutorial steps are correct. The problem is I forgot to mention that the macro must be run from Outlook. I have updated the tutorial.

This macro needs to be copied into a VBA module in Outlook. Use Alt+F11 to activate the Visual Basic Editor. Next, add a VBA reference to Microsoft Excel in you r Outlook VBA project.

Add the module and paste the macro code into it. Be sure to sign the VBA project in Outlook. The only other requirement is the Excel workbook you are using to send emails from must have been saved.

The email column format on the worksheet: Email Address, Subject, Message, File Path of Attachment (if any). You only need to provide the first cell's address. The macro will find the last entry automatically. You can modify this for your needs. If you have problems, let me know.

Please Login or Register  to view this content.

Example Macro to Send the Emails
This macro must be in your Outlook VBA project.

Please Login or Register  to view this content.