Pool Master
04-27-2008, 06:42 PM
Hi Everyone,
I'm running an Excel Macro that is sending an e-mail via Outlook every hour with an attached workbook containing an updated data pull from a production environment. My question is quite simple, though I haven't seen the question asked on this forum before.
Using VBA how do I auto select Yes from the Outlook Security Message when the e-mail is being sent? I found a link on a google search result to software called "ClickYes" and it works, but I would prefer to not have to install additional software as this is a security issue in itself.
Thank you in advance for your help!
Adam
I'm running an Excel Macro that is sending an e-mail via Outlook every hour with an attached workbook containing an updated data pull from a production environment. My question is quite simple, though I haven't seen the question asked on this forum before.
Using VBA how do I auto select Yes from the Outlook Security Message when the e-mail is being sent? I found a link on a google search result to software called "ClickYes" and it works, but I would prefer to not have to install additional software as this is a security issue in itself.
Thank you in advance for your help!
Adam