Error with automation - Access 2007 creating Outlook calendar appo

J

JoD

Per ACC2000: How to Use Automation to Add Appointments to Microsoft Outlook,
I am trying to use automation to add appointments to the Outlook calendar,
using Access 2007 Version 5.1.2600 Service Pack 2 Build 2600 (part of the
Microsoft Office 2007 Suite).
I have created my table, the form and the code as suggested. When I try to
run the code, I receive the following error:
1. Compile error: User-defined type not defined.

At this point the code Dim objOutlook As Outlook. Application is
highlighted. The Help information suggests that I add a Microsoft DAO
library, so I check Microsoft DAO 3.6 Object Library in the list of
References under Tools.
2. After selecting the Microsoft DAO library in the References, I then
receive the following error: Name conflicts with existing module, project or
object library.

In my project I use DAO recordsets, which are created as DAO.recordset

The only libraries selected are the following (in this order):
Visual Basic for Applications
Microsoft Access 12.0 Object Library
OLE Automation
Microsoft Office 12.0 Access database engine Object Library

Any help would be appreciated.
 
J

JoD

Well, I did some further checking and found that by selecting the Microsoft
Outlook 12.0 Object Library, my problem was fixed. That should have been
apparent to me before.
 

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