Below is a step by step guide to export your Microsoft Outlook contacts to Excel as well as a step by step guide to export your Windows Mail to Excel. If you are running Windows Vista follow the Windows Mail steps and any other Windows version, including Windows XP, should use the Microsoft Outlook steps.
Export Contacts from Windows Mail to Excel:
- Open Windows Mail: Click Start Icon, Click All Programs, Choose Windows Mail
- Select Contacts: From Windows Mail Select Tools, Select Windows Contacts, Left Click Windows Contacts.
- Select Export: From the center window navigation, Click Export
- Choose CSV:Select CSV [which means Excel], Click Export
- Choose Location: Click Browse and browse to the desktop
- Click Next: Verify location, Then Click Next
- Select Fields: Check the fields you want to appear in the Excel file, For instance: First Name, Last Name, and Email Address to have an excel file with three columns.
- Finish: Select Finish, Left Click
- Verification: Click OK once Windows verifies it has exported the file.
- Open Excel: Locate the file on your desktop and make sure the contacts were exported properly or email this file to the person requesting it.
Export Contacts from Microsoft Outlook
- Open Outlook: Choose MS Outlook from the start menu
- Select Export: Click File in the top navigation, Scroll down and select Import and Export
- Select Method: Highlight “Export To a File”, Click Next
- Select Type:Highlight “Microsoft Excel”, Click Next
- Select Folder: Highlight “Contacts”, Click Next
- Browser for Location: Click Browse and navigate to desktop
- Name File: Choose a name for your Excel file, Type it in, Click OK
- Move Forward: Click Next
- Verify Action: Make sure the action is correct, such as “Export Contacts from folder: Contacts”, If so Click Finish **Note you may also custom map fields as well by clicking “Map Custom Fields”.
- Verify: Wait until the progress bar is finished, Open file and verify it has exported properly.
Outlook Express should be very similar to Outlook. I was unable to find a download of Outlook Express as it is no longer included with the latest downloads of Internet Explorer.
Pick up a copy of Excel from Amazon.
A great book to really get started with Excel.
