Link to home
Start Free TrialLog in
Avatar of colinasad
colinasadFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Solution to original question worked for Outlook but does not appear to work for Outlook Express. Any suggestions?

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?

Many thanks.
Colin.

Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

You can't automate Outlook Express. MapiLabs only works with the full version of Outlook.

You can use MAPI automation, or CDO - but not OE.

Avatar of colinasad

ASKER

Thanks for the prompt response, LSMConsulting.

Apologies for appearing a bit thick here, but can you just confirm my understanding of what you are saying?
"OE" (Outlook Express ?) cannot be automated in the way the full Outlook program can?
Users with Outlook Express cannot avoid the "Allow / Deny" "Outlook Security Warning" when I try to send an e-mail from an Access application?

Regards. Colin.
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks, LSMConsulting.
I just wanted to be sure I wasn't missing anything. My client will accept that somethings can be done and others can't.
Many thanks.