FIGURE 11.16
An Outlook contact with an attachment created from an Access contact record.
Summary ..........................................................................................................................
The synchronizing techniques in this chapter will allow you to maintain your contact data in a set
of linked Access tables, adding any number of custom phone numbers and IDs as needed, and syn-
chronize your Access data to Outlook contacts, so you can work with the standard properties of
contacts in the convenient Outlook contact interface, and work with any additional custom fields
you need in Access, without having to manually enter (and update) the same contact data in
Access and Outlook.
In addition, you can use the denormalizing and renormalizing techniques used to work with con-
tacts for any situation that requires converting a set of linked Access tables to a single flat-file table,
or the reverse — something that is likely to arise when exchanging data with legacy programs or
mainframe databases.
Part II Writing VBA Code to Exchange Data between Office Components