"429:ActiveX component can't create object" error opening Outlook from Access VBA

D

dyood

Hi...I'm working on a Access project where I need to send mails with
attachments (using Outlook). I have the code for this already in a
module. If I have Outlook open while executing that piece of code, the
mail get constructed and sent just fine. But here is the problem. If
Outlook is not open already, the module attempts to open Outlook by
executing the 'objApp = CreateObject("Outlook.Application")' statement
where objapp is declared as 'Dim objApp As Outlook.Application".

Note: All this is happening on a Windows ME OS which has Office XP Pro
installed for the Microsoft office apps. The error encountered is "429
: ActiveX component can't create object" !

I understand that the problem lies in finding the reference to outlook
from within the code and a variety of remedies have been suggested from
sources online. I have performed the following tasks with UNSUCCESSFUL
results so far. Some of the things might be unwarranted or even
nonsensical, but I attempted every single thing I could (typical of
desperation, isn't it ?!)

(1) Check in the Visual Basic Editor in "Tools" -> "Reference" for the
following libraries to be checked. These libs are checked in the list:
VBA, Microsoft Access, Microsoft Outlook 10.0 Object Library, Microsoft
Office 10.0 Object Library, DAO Library

(2) Checked Object Browser to find a Outlook Application and the
"CreateObject" as one of its methods

(3) Checked Registry to find "Outlook". Also changed the reference to
"Outlook.Application.10" in, both, the code and the registry to make
sure that this is not a problem due to version numbers. It still did
not work.

(4) Ran "Regsvr32 scrrun.dll" at the command line

(5) Downloaded and installed Microsoft Scripting Runtime 5.6

(6) Ran "RegSvr32 C:\progra~1\common~1\micros~1\dao\dao360.dll" at the
command line. The dao360.dll file does exist in the specific folder.

(7) Uninstall and Installed the "Complete" version of Office XP Pro

Inspite of all these steps, I have still not found a way for the
statmemt
"objApp = CreateObject(Outlook.Application") to work.

If you have ANY other suggestions / pointers / advice etc etc. please
do post them. I know that the VBA is not able to pick up the path to
the outlook.exe folder, but my experience on the windows platform is
limited and the whole registry thing seems a maze to me. So, go ahead
and enlighten me. Thanks a lot in advance.

~dyood
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top