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 |
|---|---|
| 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 ...
Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
