Problem reading in MS Access

M

Michael S. Montoya

I had a routine in Microsoft Access 2000 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 that occurs at
the Set statement.

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, 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.

Are there 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.
Any suggestions?
 
Top