In Microsoft Outlook for Windows, how do I export my contacts to Excel or Access?

Note: UITS may no longer be able to verify the accuracy of information regarding Windows versions of Outlook older than 2000, and may not have the materials necessary to support them. Therefore, UITS recommends that you upgrade to a current version. At Indiana University, you can download a current version of Microsoft Office for Windows, which includes the current version of Outlook for Windows, from IUware Online. If you are in a department or using a Macintosh Outlook client, contact your local support provider (LSP) or the UITS Support Center before upgrading or changing your software.

To work with your Microsoft Outlook contacts in Access or Excel:

1. Open Outlook and from the File menu, select Import and Export... . The Import and Export wizard will open.
   
   
2. Choose Export to a file and click the Next button.
   
   
3. Choose Microsoft Access or Microsoft Excel, depending on how you want to work with your data. Click Next.
   
   
4. Select the Contacts folder and click Next.
   
   
5. In the resulting dialog box, enter a path and name for the exported file (e.g., C:\Windows\Desktop\Contacts.xls). Click Next.
   
   
6. In the resulting dialog box, under "The following actions will be performed:", select the checkbox next to the listed item (if it is not already selected).
   
   Note: In Outlook 97, you can also click the Map Custom Fields... button to display a dialog box in which you can specify the fields you want to include in the exported file. (This step is not necessary in Outlook 98.) The list on the right of the Mapped Custom Fields dialog box displays the fields that are already designated to appear in the exported file. To specify only the fields you want, click the Clear Map button to clear the list of field titles. Then, drag the field titles you want to include in the exported file from the list on the left to the empty list on the right. When you've made all your choices, click OK.
   
   
7. Click Finish. Outlook will create a new file containing your contacts in the exported format you designated.

Also see:

• In Microsoft Outlook, how can I import address information from an Excel workbook into my Contacts list?
• In Microsoft Outlook 2002 and earlier, how do I add a picture of someone to my Outlook Contacts?
• In Microsoft Outlook, how do I print a phone list from my Contacts list?
• In Outlook for Windows, how do I export my messages or folders to a Personal Folder file, Excel workbook, or Access database?
• In Outlook 2000 and earlier for Windows, how do I use information in my Contacts folder to print envelopes for mailing?