HOWTO Export contacts from Outlook to Excel.

This HOWTO article applies to Microsoft Office 2007. I think it should work for Microsoft Office 2003 as well. This is to export your Outlook Contacts information to an Excel worksheet. A little information to share about the difference between Outlook Address Book, and Outlook Contacts. "They are both part of Outlook. However, the Address Book is a compilation of the different address lists you might have stored in Outlook, such as Personal Address Book (.pab), LDAP Internet directories, the Global Address List (GAL), or other third-party address books. Contacts is just one of the address lists that makes up the Address Book." (2010, Office.Microsoft.com)


Here's the step by step guide.

• In Outlook, on the File menu, click Import and Export
• Click Export to a file, and then click Next.
• Click Microsoft Excel, and then click Next.
• In the folder list, click the Contacts folder, and then click Next.
• Browser to the folder where you want to save the contacts as an Excel file (.fls)
• Type a name for the exported file, and then click OK.
• Click Next.
• Click Finish.

See attached captured files for additional information. I hope this help you.