I'm using Access 2010 and Outlook 2010 and wrote a VBA method in Access that sends an email. The basic code looks like this:
Set mailSender = New Outlook.Application Set mail = mailSender.CreateItem(olMailItem) ... mail.Save mail.Send
I have anti-virus running and when I call this method the email is sent without a security prompt. This works great!
Now, if I use the SendEmail action in a data macro, it sends an email just fine, but I get the anoying security dialog that I have to deal with. I assume the macro approach is going through different system layers and is viewed differently by Outlook.
Is there a way to configure this so the macro does not require the security dialog?
I can't call the Redemption library from a macro. The VBA code works great; the changes made in 2010 should mostly eliminate the need for the Redemption library since the dialog is supressed as long as the anti-virus is active and up-to-date. The problem I'm having with the SendEmail action. How ever this was coded, internally, does not seem to be compatible with the security enhancements.
Have you resolved your problem yet, and do the suggestions help you? If you still have any concern on the thread, feel free to follow up.
Bruce Song [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Thanks for following up. Outlook 2010 was enhanced to allow programmatic access without the annoying security dialog as long as anti-virus software is installed and up-to-date. And this works great when sending email from Access using VBA. Kudos to Microsoft as this was a much needed improvement. However, when called through a data macro I still get the dialog box.
My question is for someone at Microsoft to confirm that this is expected and we have to use one of the suggested third-party solutions to "cover-up" the problem. Or, is there a way to configure the solution to take advantage of the 2010 improvements and avoid the dialog altogether.
I have never seen or heard of this: "Outlook 2010 was enhanced to allow programmatic access without the annoying security dialog as long as anti-virus software is installed and up-to-date. And this works great when sending email from Access using VBA."
It clearly is not the case for me or my clients.
Check out this article for details. http://msdn.microsoft.com/en-us/library/ff864479.aspx