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:
In Outlook 2007, choose File, Import And Export to open the Import And Export Wizard.
Select Export To A File, and then click Next.
Select Microsoft Excel 97-2003, and then click Next.
Select the folder from which to export data. In this case, select the Contacts folder or another folder that includes ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access