Solved: Outlook contacts export

ramon82 · 10-09-2008

Outlook contacts export

Hi all

I would like to know if there is any application allowing you to export the contact details of outlook to an Excel file?

Thanks!

Jelly Bean · 10-09-2008

Hello and welcome back to PCHelpForum.

We have a great Tech Team who will help you with your issue do not worry.

I have marked your thread as "Open" in readyness for the team.

JB.

philharris433 · 10-09-2008

Hi,

This can be done in outlook, by going to File, import and export, Export to a file and then choose microsoft excel, then choose the contacts folder and where you want to save it.

ramon82 · 10-09-2008

Ok using FILE>IMPORT/EXPORT from outlook works.

I now noticed that the ADDRESS field is not distributed in one line but on multiple lines in one cell. In fact now a letter in the form of a square is being printed to indicate that there is a multiple line entry. See http://img392.imageshack.us/img392/8...ture222ol3.jpg for more detail.

Any idea how can I get rid of this?? cannot make it manually as addresses amount to over 3000 and I need to print them in a mail merge!!

Many Thanks

elpmek · 10-09-2008

Try exporting as a Comma Separated Value (windows) file.

Open with Excel

ramon82 · 10-13-2008

Problem solved. Exported from outlook to a CSV file and then created a DOC file with a mail merge. Data exported and printed successfully. Thanks for all your help

10-09-2008	#1
ramon82 Bronze Member Join Date: Aug 2008 Posts: 57 PC Experience: Experienced	Outlook contacts export Outlook contacts export Hi all I would like to know if there is any application allowing you to export the contact details of outlook to an Excel file? Thanks!

10-09-2008	#2
Jelly Bean Stoooooopid Girl. Join Date: Feb 2008 Location: Swansea Posts: 12,804 PC Experience: None.	Re: Outlook contacts export Hello and welcome back to PCHelpForum. We have a great Tech Team who will help you with your issue do not worry. I have marked your thread as "Open" in readyness for the team. JB. __________________ Rwy'n ceisio fy ngorau.

10-09-2008	#3
philharris433 Gold Member Join Date: Sep 2007 Posts: 256	Re: Outlook contacts export Hi, This can be done in outlook, by going to File, import and export, Export to a file and then choose microsoft excel, then choose the contacts folder and where you want to save it.

10-09-2008	#4
ramon82 Bronze Member Join Date: Aug 2008 Posts: 57 PC Experience: Experienced	Re: Outlook contacts export Ok using FILE>IMPORT/EXPORT from outlook works. I now noticed that the ADDRESS field is not distributed in one line but on multiple lines in one cell. In fact now a letter in the form of a square is being printed to indicate that there is a multiple line entry. See http://img392.imageshack.us/img392/8...ture222ol3.jpg for more detail. Any idea how can I get rid of this?? cannot make it manually as addresses amount to over 3000 and I need to print them in a mail merge!! Many Thanks

10-09-2008	#5
elpmek Tech Support Team Join Date: Feb 2006 Location: Gloucestershire Posts: 2,900 PC Experience: Experienced	Re: Outlook contacts export Try exporting as a Comma Separated Value (windows) file. Open with Excel

10-13-2008	#6
ramon82 Bronze Member Join Date: Aug 2008 Posts: 57 PC Experience: Experienced	Re: Outlook contacts export Problem solved. Exported from outlook to a CSV file and then created a DOC file with a mail merge. Data exported and printed successfully. Thanks for all your help

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode