VBA Email

[rajag4]

I have a list of email addresses and a worksheet of data with various sections that relate to each address. I have been able to parse the data to the appropriate email address and have even figured out how to email the separate worksheets. However for every email I get the following notification:

A program is trying to send an e-mail message on your behalf. If this is unexpected, click Deny and verify your antivirus software is up-to-date. For more information about e-mail safety and how you might be able to avoid getting this warning, click Help.

Does anyone know how to avoid this warning or to have the macro automatically respond with Allow to this message?

Thanks

[Leith Ross]

Hello rajag4,

Welcome to the Forum!

The message is part of Outlook's enhanced security. Unfortunately, VBA can not automatically respond to the dialog for you.

The best approach is write your macro to send multiple emails at one time. This way you have to answer the dialog only once. However, you said you are emailing separate worksheets and this approach may not work.

If you post a copy of your workbook then I can offer you more help. Please redact any sensitive or confidential data before posting your workbook.

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

[rajag4]

Leith,

Thanks - I have posted a copy of the workbook with some made up data. While this workbook shows currently only two vendors the true data could have several hundred, thereby meaning several hundred emails to go out.

Any way I could avoid the warning each time would be terrific.