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

Posted on 2011-04-29
Last Modified: 2012-08-14
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.
Question by:wrogge
    LVL 26

    Accepted 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
    LVL 84
    I've been using vbMAPI from, 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.
    LVL 74

    Expert Comment

    by:Jeffrey Coachman more, in case money is no object

    Author Closing Comment

    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.
    LVL 26

    Expert Comment

    <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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Sorry for my English and Italian screenshots..... Problem: Every Year the number of E-Mails grow dramatically and the space that they take on Exchange Servers or .PST files, grow much more faster, once it was only text, now our E-Mail Archives …
    Check out this infographic on what you need to make a good email signature that will work perfectly for your organization.
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now