O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

USING AUTOMATION TO DRIVE OUTLOOK FROM ACCESS

Driving Outlook from Access is actually easier, in my opinion, than driving from some of the other Office products. Even though Outlook uses VBScript for its language, from Access it codes just like any other Office app but with a simpler object model.

Most objects you will create will be different types of one object, called an Item. Here are the possible items, with their Outlook.OlItemType enum equivalents used with the CreateItem method:

Item enum
Mail olMailItem
Appointment olAppointmentItem
Contact olContactItem
Task olTaskItem
Journal olJournalItem
Note olNoteItem
Post olPostItem

When you specify the type of item you will use, the properties particular to that type can then be accessed. The ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required