Import Access Data into Outlook

If you have contact data in Access that you'd like to transfer to Outlook, your best bet is to use the import tools in Outlook, as follows:

1.
Select View, Navigation Pane and click Contacts.
2.
Choose File, Import and Export.
3.
Select Import from Another Program or File.
4.
Choose Microsoft Access.
5.
Follow the instructions in the rest of the wizard.

I know this last instruction is feeble, but I don't think you'll have difficulty with the wizard. The only interesting dialog box is Map Custom Fields, shown in Figure 13.12. Here you match the fields in the table (say, CustLastName) with the fields in your address book (say, Last Name) by dragging the Access field in the left pane to the Outlook field in the right ...

Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills 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.