Import/Export Outlook Contacts

Solution • To export Outlook Contacts to a .CSV file
• Select File | Import and Export... from the menu.
• Make sure Export to a file is highlighted.
• Click Next >.
• Now make sure Comma Separated Values (Windows) is selected.
• Click Next > again.
• Highlight the Contacts folder.
• Click Next >.
• Use the Browse... button to specify a location and file name for the exported contacts. Something like "Outlook.csv" or "ol-contacts.csv" on your Desktop should work fine.
• Click Next > (once more).
• Contacts will then be exported into a .csv file to be re-imported into another machine

To import contacts from a .CSV file or from Excel into Outlook:
• Select File | Import and Export... from the menu in Outlook.
• Make sure Import from another program or file is highlighted.
• Click Next >.
• Now make sure Comma Separated Values (Windows) is selected.
• Click Next >.
• Use the Browse ... button the select the desired file.
• Typically, choose Do not import duplicate items.
• Click Next >.
• Select the Outlook folder you want to import the contacts to. This will usually be your Contacts folder.
• Click Next >.
• Click Map Custom Fields ....
• Make sure all columns from the CSV file are mapped to the desired Outlook address book fields.
• You can create new mappings by dragging the column title to the desired field.
• Any previous mapping of the same column will be replaced with the new.
• Click OK.
• Now click Finish.

Was this article helpful? yes / no

Use Contact Categories as Distribution Lists in Outlook 2007

Sending Faxes from Windows Fax and Scan

Convert an Excel Sheet in to the CSV (Comma Separated Values) Format

Droid - Exchange email setup

Importing a CSV File in to Outlook 2010

Article details

Article ID:	34
Category:	MS Office
Date added:	2010-06-24 23:26:55
Views:	388
Rating (Votes):	(68)

« Go back