Microsoft® Office Outlook® 2007 Inside Out

Exporting Contacts to Access

Another way to use Outlook 2007 contact information is to export the data to Access 2007, which is handy if you want to use contact data in database tables or reports. You could spend your time opening individual contact entries in Outlook 2007, copying information from the contact form, and then pasting the information into Access 2007 where you want it. However, Outlook 2007 makes the process much simpler. All you have to do is use the Import And Export Wizard and select Microsoft Access 2007 as the file to export to.

Here’s how to export contact information to Access 2007:

1. In Outlook 2007, click File and then Import And Export to open the Import And Export Wizard.

2. Select Export To A File and then click Next.

3. On the ...