FIGURE 8.7
A linked Outlook Tasks folder, lacking the Subject field.The linked olCalendar table (shown in Figure 8.8) does include the Subject field, as well as many
mysterious and irrelevant fields such as MessageToMe and MessageCCToMe, but it lacks the crucial
Start and End dates and times, so it is also useless.FIGURE 8.8
A linked Outlook calendar.Of the three, the linked olContacts table provides the best match for Outlook contacts: it does have
most (but not all) of the standard contact item fields (though not the Customer ID field, which
could be useful in linking records). However, the promise of linking Access tables to Outlook —
specifically that changes made in Access will be saved to Outlook, and vice versa — is not com-
pletely fulfilled. For example, though I made changes to both the contact name and company
name for a contact record in Access, only the company change was reflected back to Outlook.
However, both contact and company name changes in Outlook were reflected to Access. Figure 8.9
shows the linked olContacts table.Part II Writing VBA Code to Exchange Data between Office Components