Security dialog when sending e-mails from Microsoft Access through Outlook
Posted on 2011-04-29
Thanks to a number of more intelligent users than myself, I have finished a project to e-mail individual report outputs to the expected recipients.
During the execution, however, I receive a security dialog (that waits) asking to 'Allow', 'Deny' or 'Cancel' on each and every e-mail message.
I have investigated this on numerous sites and they all direct to making a change in the 'Outlook', 'Trust Center' for the 'Programmatic Access' section. I have modified this in both my Outlook 2007 (test platform) and my Outlook 2010 (production platform). I have set them to the 'Never warn me about suspicious activity (not recommended)' setting.
This makes NO difference at all. With a typical mailing being over 100 messages, the eventual user could sit there and keep clicking the 'Allow' option, but I would rather eliminate the dialog all together.
Please tell me there is a solution that actually works for this.