We help IT Professionals succeed at work.

import contacts when using exchange

jwcse
jwcse asked
on
Medium Priority
218 Views
Last Modified: 2011-10-03
SBS 2003 server with exchange running
Outlook installed on client pc's and imported outlook.pst file
All emails have imported ok, however the contact s list has not?  I have tried again to import selecting just the contacts folder but no contacts a transfered.
Can you help
Jon
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2008

Commented:
Greetings, jwcse !

Is the client's contacts list on the PST file or on Exchange?  If Exchange, then you need to export the contacts from Exchange to a CSV file. Then import the CSV file into the new PST file.

If on client's PST file, export the contacts list as a CSV file. Then import the file to the new PST folder.

Best wishes!
Export Outlook Contacts

In Outlook, on the File menu, click Import and Export.
Click Export to a file, and then click Next.
Click Comma Separated Values (Windows), and then click Next.
In the folder list, click the Contacts folder, and then click Next.
Browse to the folder where you want to save the contacts as a .csv file.
Type a name for the exported file, and then click OK.
Click Next.
Click Finish.

Outlook can import from a variety of programs
Depending on the program the address book file is in, you'll either import it directly, or save it in another file format and then import it.

Import your address book directly from an e-mail program
In Outlook, on the File menu, click Import and Export.
Click Import Internet mail and addresses, and then click Next.
In the list, click the program you want to import from.
If your address book file is in a program not listed, you must save it in either the Tab Separated Value (.tsv) or the Comma Separated Value (.csv) format.

Save the file in .tsv or .csv format
In the program in which you have your e-mail addresses stored, save the file in .tsv or .csv format.

If you do not see .tsv or .csv in the Save as type list, it might still be possible for you to save the file in one of these formats. Many programs provide a text format in which to save files that does not make it clear whether the information in the file will be tab separated, comma separated, or neither. If the program from which you're saving is one of these programs, save the file in text format, and then open it in a text editor such as Microsoft Windows® WordPad. Look to see whether the information in the file is separated by either tabs or commas. If it is, change the file extension of the file from *.txt to .tsv or .csv as appropriate.

If after you save the file as a text file the contents are not separated by either tabs or commas, import the file into a Microsoft Office program such as Microsoft Excel or Microsoft Access. Then save the file in .tsv or .csv format.

Import your .tsv or .csv file into Outlook
On the File menu, click Import and Export.
Click Import from another program or file, and then click Next.
In the list, click either Comma Separated Values (Windows) or Tab Separated Values (Windows), depending on which format you saved your file in, and then click Next.
Click Browse, locate your file, and then click Next.
Click your Contacts folder or another folder that contains contacts, and then click Next.
In the list, click the file that contains your address list, and then click Map Custom Fields.
Translate your entries into Outlook fields
You'll need to translate the values in your file to fields that are used in Outlook. If your e-mail address list is saved as a table, the first row you'll see in the From box of the Map Custom Fields dialog box will be the table column headings. Drag each column heading from the From box to the correct Outlook field in the To box.

By dragging and dropping the column headings, you can quickly assign all the values in your records to their equivalent values in Outlook. When you have finished, click OK, and then click Finish. Your e-mail addresses will be imported into the Contacts folder in Outlook.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
CERTIFIED EXPERT
Top Expert 2008

Commented:
jwcse,

We have not heard from you. Did any comment help you solve your problem? Do you have any more question? If an Expert helped you, please accept his/her answer above with an excellent or good grade.

Thanks, war1

Author

Commented:
Thank you for your help
Regards
Jon
CERTIFIED EXPERT
Top Expert 2008

Commented:
Jon, did I not post the correct answer first?  At Experts Exchange, the first correct gets the points.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.