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 And Export Wizard.

  2. Select Import From Another Program Or File, and then click Next.

  3. Select Microsoft Excel 97-2003, and then click Next.

  4. In the File To Import text box, type the name of the file or browse to the Excel 2007 file (XLS) that you want to import.

  5. Specify how you want Outlook 2007 to handle duplicates, and then click Next.

  6. Select the destination folder in which you want the imported data to be placed, such as the Contacts folder, and then click Next.

  7. In the Import A File dialog box, click Map Custom Fields. In this dialog box, you can add or remove field items, modifying the way in which the imported items are saved in your Contacts list. When you finish verifying or modifying your field mappings, click OK.

  8. Click Finish to start the import process. You might want to review your contacts to ensure that the data was imported the way you need it. If it wasn’t, modify it as necessary in Outlook 2007.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset