Microsoft® Office Outlook® 2007 Inside Out

Exporting Contacts to Excel

You might also find it useful to export Outlook 2007 contact information to Excel 2007 worksheets. In Excel 2007, you can include the data in a spreadsheet of names and addresses for a contact management sheet, sort contact data in various ways, or perform other spreadsheet tasks with the data. Again, you simply use the Import And Export Wizard to create this Excel 2007 file.

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

1. In Outlook 2007, choose File, Import And Export to open the Import And Export Wizard.

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

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

4. Select the folder from which to export data. In this case, select the Contacts folder or another folder that includes ...