Link to home
Start Free TrialLog in
Avatar of jwcse
jwcse

asked on

import contacts when using exchange

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
Avatar of war1
war1
Flag of United States of America image

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!
Avatar of gopal_krishna
gopal_krishna

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.
ASKER CERTIFIED SOLUTION
Avatar of gopal_krishna
gopal_krishna

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Avatar of jwcse

ASKER

Thank you for your help
Regards
Jon
Jon, did I not post the correct answer first?  At Experts Exchange, the first correct gets the points.