p2p.wrox.com Forums - Automation Error

p2p.wrox.com Forums (http://p2p.wrox.com/)

- BOOK: Access 2003 VBA Programmer's Reference (http://p2p.wrox.com/book-access-2003-vba-programmers-reference-133/)

- - Automation Error - Library Not Registered (http://p2p.wrox.com/book-access-2003-vba-programmers-reference/79453-automation-error-library-not-registered.html)

Automation Error - Library Not Registered

Please Help!!!! When I run the code below in a Windows 7 environment I get an error: Automation Error - Library Not Registered. This code works great in Windows XP with Access 2003. I think this has something to do with a missing DLL file but I am not sure. Does anybody know how to resolve this problem?

Set olApp = CreateObject("Outlook.Application")

Set olNS = olApp.GetNamespace("MAPI")
Set olfolder = olNS.GetDefaultFolder(olFolderInbox)
Set olMailItem = olfolder.Items.Add("IPM.Note")

Thank you for any help you can give.

You should check the references in your database. Search for the outlook reference (Microsoft Outlook ..... Object library) and add it to your references.
That should help.