outlook activex error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael S. Montoya - 05 Feb 2005 03:02 GMT

I had a routine that worked once upon a time and I can't think of what could
have made it stop working.

here is what I have:

Dim objOutlook As Outlook.Application
Dim nms As Outlook.NameSpace
Dim fld As Outlook.MAPIFolder
Dim itms As Outlook.Items
Dim itm As Outlook.MailItem

Set objOutlook = CreateObject("Outlook.Application")

I am using this to loop through the Inbox and look for a specific subject
line.
I now get the error: ActiveX component can't create object

and it is happening on more than one computer in the office. We have Office
2000 and Outlook 2003. I belive it has been like this even when it use to
run. I have DAO 3.6, ADO Ext. 2.8 for DDL and Security, Office 11.0 Object
Library, and Outlook 11.0 Object Library. My computer in particular has
been recently reinstalled with Office and Outlook, so I am guessing the
installs are ok.

Any suggestions?

Reply to this Message

Douglas J. Steele - 05 Feb 2005 13:27 GMT

Even though you've reported on the References, it could still be a problem
with the References collection.

On the machine(s) where it's not working, open any code module. Select Tools

| References from the menu bar. Examine all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I had a routine that worked once upon a time and I can't think of what
>could
[quoted text clipped - 24 lines]
>
> Any suggestions?

Reply to this Message

Michael S. Montoya - 10 Feb 2005 19:15 GMT

Thanks for the tips, but they didn't work either. There were no missing. I
unselected all that it let me. I closed the database, reopened it,
re-selected the references and compiled. It still gave the error at the
line:

Set objOutlook = CreateObject("Outlook.Application")

Any other ideas. This code use to work fine as is.

> Even though you've reported on the References, it could still be a problem
> with the References collection.
[quoted text clipped - 43 lines]
> >
> > Any suggestions?

Reply to this Message

Michael S. Montoya - 10 Feb 2005 19:17 GMT

Are they alternate ways/code to access the attachments of your inbox. I am
looking for a specific subject line and there are emails coming in from 4
different people so I need to loop through each email and run the import
routine.

Thanks in advance.

> Even though you've reported on the References, it could still be a problem
> with the References collection.
[quoted text clipped - 43 lines]
> >
> > Any suggestions?

Reply to this Message

Douglas J. Steele - 11 Feb 2005 22:39 GMT

You might have better luck asking in one of the Outlook newsgroups.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Are they alternate ways/code to access the attachments of your inbox. I
> am
[quoted text clipped - 60 lines]
>> >
>> > Any suggestions?

Reply to this Message