• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 318
  • Last Modified:

Security dialog when sending e-mails from Microsoft Access through Outlook

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.
1 Solution
There are a few solutions
One is ClickYes
When active it takes care of the clicking for you
Another is MAPILabs product

Both are free
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I've been using vbMAPI from www.everythingaccess.com, and really like the product. It does not require any additional deployment items, as all the necessary code is contained in specailly created C packages directly in VBA. It completely avoids the security dialog, and also provides a wealth of other features.
Jeffrey CoachmanCommented:
...one more, in case money is no object

wroggeAuthor Commented:
The mapilib did not work witht he dialog I was receiving yet the Click-Yes worked perfectly.  Just amazed that Microsoft's documented solution does not work.  Hurray for third party software.
<Just amazed that Microsoft's documented solution does not work>
MAPILabs is not Microsoft.  They are third-party too.
But, no matter what you may have read elsewhere, you cannot eliminate the Outlook Security Object Model with just settings.
We'd have all done that, including the virus-writers!, if we could.
I think what you probably read was about changing OUTLOOK's security settings.
Outlook itself can be locked down so that no code within Outlook works, or freed up so you can write VBA code in Outlook that will work

Glad ClickYes worked for you.

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now