Access 2007 on WinServ2008Standard - SendObject comes up with allow/deny

Posted on 2012-09-19
Last Modified: 2012-09-21
Access 2003 (MDB) database using SendObject command.  Works fine on an old XP box running Office 2003 apps and ClickYes, connecting to Exchange Server 2007.

Moving apps to a new box running Windows Server 2008 Standard and Office 2007.
SendObject command keeps popping up with the "allow/deny" sending of the e-mail message.  Have set up Trust Center in Access/Outlook to allow macros, programmatic access, etc....still doesn't work.  

Any suggestions on how to eliminate that allow/deny popup?
Question by:ParisBP
    LVL 6

    Accepted Solution

    It is Outlook Security...

    Try an app like MapiLabs

    Author Comment

    Thanks for the suggestion.  I installed their Advanced Security for Outlook yesterday even though WinServ2008Standard is not listed in their system requirements...did not work.  When trying to run the task (WinServ task scheduler, calls the Access macro via commandline switches) *OR* manually executing the macro in Access itself, I never received a prompt from the MAPILab application to set the allow/deny access value as indicated in the small graphic at the top of that webpage.

    Sidenote - within Outlook 2007's Programmatic Access, message appears as "Antivirus status:  unavailable.  This version of Windows does not support antivirus detection".  We're running Symantec Enpoint Protection and the machine is considered punching holes in the registry to get the messages out is certainly an acceptable option.  Tried a couple of entries that I saw elsewhere, but they didn't work either (to reg key location HKLM/SOFTWARE/Microsoft/Office/12.0/Outlook/...)

    Another option (?) - uninstall Outlook 2007 and install Outlook 2003...don't know about potential for version conflicts...
    LVL 1

    Assisted Solution

    If you can upgrade to Access 2007 you can use the "CreateObject("Outlook.Application")" and it bypasses the Outlook "allow/deny popup".


    Author Comment

    We're using Access/Outlook 2007 already...running on WinServ2008Standard.  Connecting to Exchange Server 2007.  All of our automation is running straight off pure Access VBA.  Outlook is open/minimized at all times.  I threw out the idea of switching Outlook back to 2003 if there were no complications.  Just throwing ideas at the wall now, trying to see what'll stick.  Thanks for the response.

    Author Comment

    Have also tried making registry changes as suggested on Microsoft site for
    [HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\12.0\Outlook\Security] and DWORDS (value 2 for autoapprove) on PromptSimpleMAPISend, PromptSimpleMAPINameResolve and PromptSimpleMAPIOpenMessage.

    As mentioned above, we are on Access/Outlook 2007 (32 bit, connecting to Exchange Server 2007) and Windows Server 2008 Standard (64 bit).

    Running out of guesses and time...

    Author Comment

    Opted to go with ClickYes Pro...seems to work fine for what we're looking to do.  
    Thanks to those who responded.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Email statistics and Mailbox database quotas You might have an interest in attaining information such as mailbox details, mailbox statistics and mailbox database details from Exchange server. At that point, knowing how to retrieve this information …
    Learn more about how the humble email signature can be used as more than just an electronic business card. When used correctly, a signature can easily be tailored for different purposes by different departments within an organization.
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    745 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

    16 Experts available now in Live!

    Get 1:1 Help Now