Our November Competition
User Reviews - Add Yours!
The PCHF Lounge
Go Back   PC Help Forum » Operating Systems » Windows XP/2000
Register for a Free Account

Windows XP/2000 - Outlook contacts export posted in the Operating Systems forums; 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!...


Reply
Free PC Performance Scan
Old 10-09-2008   #1
Bronze Member
 
Join Date: Aug 2008
Posts: 57
PC Experience: Experienced
Default 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!
ramon82 is offline   Reply With Quote
Advertisement - Register to Remove
Old 10-09-2008   #2
Stoooooopid Girl.
 
Jelly Bean's Avatar
 
Join Date: Feb 2008
Location: Swansea
Posts: 12,727
PC Experience: None.
Default 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.
Jelly Bean is offline   Reply With Quote
Old 10-09-2008   #3
Gold Member
 
Join Date: Sep 2007
Posts: 226
Default 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.
philharris433 is offline   Reply With Quote
Old 10-09-2008   #4
Bronze Member
 
Join Date: Aug 2008
Posts: 57
PC Experience: Experienced
Default 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
ramon82 is offline   Reply With Quote
Old 10-09-2008   #5
Tech Support Team
 
elpmek's Avatar
 
Join Date: Feb 2006
Location: Gloucestershire
Posts: 2,723
PC Experience: Experienced
Default Re: Outlook contacts export

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

Open with Excel
elpmek is offline   Reply With Quote
Old 10-13-2008   #6
Bronze Member
 
Join Date: Aug 2008
Posts: 57
PC Experience: Experienced
Default 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
ramon82 is offline   Reply With Quote

Reply


Bookmarks

Tags
contacts, export, fixed, Fixed:, open, outlook

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are On




All times are GMT. The time now is 09:27 AM.
Powered by vBulletin
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2