Access.2007.VBA.Bibl..

FIGURE 11.1

The Relationships diagram for the Synchronizing Contacts database.

Because Outlook only supports a fixed number of addresses and emails (three of each), and a

larger (17) but still fixed number of phone numbers, for purposes of synchronizing contact data

between Outlook and Access, only the matching addresses, emails, and phone numbers will be

synchronized. Practically, this is not likely to leave much data unsynchronized, except in the case

of phone numbers.

For best results when synchronizing data, when entering a phone number or ID in one

of the subforms on frmContactInfo, select one of the default selections for addresses,

emails, and phone numbers from the drop-down list; they are the only selections that will be synchro-

nized with Outlook contact items.

Figure 11.2 shows a phone number being selected on the Contact Information (frmContactInfo) form.

TIPTIP

Synchronizing Access and Outlook Contacts 11