Importing Contacts from Excel

You import contact information from an Excel 2007 worksheet the same way you import from an Access 2007 database. Suppose that your coworker wants to send you contact information but is not running Outlook 2007. Ask the coworker to save the data in an Excel 2007 worksheet and send that file to you. You can then use the Import And Export Wizard to import the new contact information into Outlook 2007.

Before you begin the process, make sure that the worksheet you want to import is closed in Excel 2007. If it isn’t closed, you’ll receive an error message when Outlook 2007 tries to find the data source.

Then follow these steps to import the data:

  1. Switch to Outlook 2007. Click File and then Import And Export to open the Import ...

Get Microsoft® Office Outlook® 2007 Inside Out 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.