Solution to original question worked for Outlook but does not appear to work for Outlook Express. Any suggestions?
Posted on 2011-03-25
My original question was how to avoid the "Outlook Security Warning" message asking the user to "Allow" or "Deny" every single e-mail being created by an Access (.ADP Project) application.
The solution was to change from my original "DoCmd.SendObject" method to using a "CreateObject("outlook.application")" method in conjunction with MAPILab's "Advanced Security for Outook" add-in.
Although this seemed to work a treat on my development laptop, where I have a full copy of Outlook, it does not appear to work on my client's PCs where they tend to only have Outlook Express.
At the "CreateObject("outlook.application")" step in the VBA code, they are getting the error message :
Error Number : 429
Error Description : ActiveX component can't create object
Is a full version of Outlook required for this method?
Is there an alternative that can be suggested that would also work with Outlook Express?