Exporting Contacts

D

dmwesq

I have 50+ e-mail addresses that I would like to export to a CSV file.
The names are in a distribution list, yet I can't seem to export them
or even cut and paste into excel. About the only thing I have been able
to do is export my entire contact list to a .txt file which does not
help me.
 
M

Michel Bintener

Hi,
Paul Berkowitz's shareware script Export-Import Entourage X, which has a
free trial period, should do the job. You can find the script here:
http://files.macscripter.net/scriptbuilders/Entourage/exportimportentouragex
_135.sit
Actually, you should be able to open the .txt file created by Entourage with
Excel, and then save it as a .csv file. Some people encounter problems when
using that method, however (Yahoo's webmail address book for instance will
not recognise that file properly), so you might as well try the above
AppleScript.

Michel
 
D

dmwesq

The shareware has free trial for only 25 items, and I don't feel like
spending $20 on something these ridiculously priced Microsoft programs
should be able to do.
I went the export route, but even though I have all these names in the
distribution list, because they are not listed individually in the
contacts list the export feature doesn't pick them up. I'm astonished
that there is no way to take a group of names from a distribution list
and transfer that data elsewhere.
 
D

Daiya Mitchell

Hmm. I just selected the names in the group, and dragged them into an open
TextEdit window, and they came, as one paragraph. Ditto in Excel. Then I
did the same in Word and ran a Find& Replace to get one name per line,
instead of one bunched paragraph. Once I had them one name per line, I was
able to copy and paste them into an untitled group, or into Excel.

Does that help at all? I'm a little confused about what you've tried and
haven't tried.

My group was all set up as just email addresses marked by <address>, so the
Find&Replace was pretty easy--if the names were also there "Name" <address>,
the F&R would be a little more complex. I used Word just because I am most
familiar with that F&R. But I imagine once the data is in a form that can be
manipulated, you should be able to get it to CSV format?

DM
 
P

Paul Berkowitz

I just worked out a way to do it with group members that include

Full Name <email address>

and also works for plain email address members. It starts as Daiya did.

1. Open the group in Entourage
2. Select all.
3. Drag selection to a new Word document.
4. It should all be selected, or select all.
5. Go to Table/Convert/Convert Text to Table.
6. At the bottom of the Convert dialog, in "Separate text at", click
"Other", and enter ">" [no quotes].
7. At the top (Table Size), change Number of columns to 1. (Number of rows
will change automatically. Leave it be.) Click OK.
8. Still all, selected, go to Table/Convert/Convert Table to Text.
9. Leave (or choose) "Separate text with" at "Paragraph marks". Click OK.
10. Still all selected, Edit/Replace... (shift-cmd-H).
11. In the Find box enter: ^p
12. In the Replace box enter: >^p
13. Click Replace All, and close box.
14. Remove the 2 extra ">" lines at the bottom.

Done. You can select all, copy and paste into an Excel worksheet if desired.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.
 
P

Paul Berkowitz

Ooh, I found a quicker way, only for Office 2004.

1. Open Tools/Scrapbook in both Entourage and Word.
2. Go to the group in Entourage - DON'T open it, just select it.
3. Edit/Copy to Scrapbook (shift-cmd-C). Optionally rename it from "New
Clipping" in the Scrapbook.
4. In Word, with a new Document open, select the same Clipping in Scrapbook,
and click Paste. (It pastes the list here delimited by comma+space.)
5. Select all. Go to Table/Convert/Convert Text to Table.
6. In the Convert Dialog, change "Separate text by" to Commas.
7. Change Number of Columns to 1. Click OK.

You now have a selected table just how you want. Optionally, you can go back
Table/Convert Table to Text, using Paragraphs as delimiters. But it's fine
as is: you do not need to tidy up or remove any lines (no do you if
converting back to text). No more steps. You can also Copy and paste into
Excel as is.

The only possible problem is that every line (row) after the first one
begins with a space. If you want to remove those spaces, then after Step 4,
interpolate:

4a. Select all. Edit/Replace. In Find box enter ", " (comma+space, no
quotes).
4b. In Replace box enter "," (comma, no quotes). Click Replace All.


That adds a few steps but gives a perfect result, easier than opening the
group, selecting all and dragging to Word, all of which can be fiddly.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.

From: Paul Berkowitz <berkowit@spoof_silcom.com>
Newsgroups: microsoft.public.mac.office.entourage
Date: Sun, 17 Apr 2005 11:46:13 -0700
Subject: Re: Exporting Contacts

I just worked out a way to do it with group members that include

Full Name <email address>

and also works for plain email address members. It starts as Daiya did.

1. Open the group in Entourage
2. Select all.
3. Drag selection to a new Word document.
4. It should all be selected, or select all.
5. Go to Table/Convert/Convert Text to Table.
6. At the bottom of the Convert dialog, in "Separate text at", click
"Other", and enter ">" [no quotes].
7. At the top (Table Size), change Number of columns to 1. (Number of rows
will change automatically. Leave it be.) Click OK.
8. Still all, selected, go to Table/Convert/Convert Table to Text.
9. Leave (or choose) "Separate text with" at "Paragraph marks". Click OK.
10. Still all selected, Edit/Replace... (shift-cmd-H).
11. In the Find box enter: ^p
12. In the Replace box enter: >^p
13. Click Replace All, and close box.
14. Remove the 2 extra ">" lines at the bottom.

Done. You can select all, copy and paste into an Excel worksheet if desired.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.

From: Daiya Mitchell <[email protected]>
Newsgroups: microsoft.public.mac.office.entourage
Date: Sun, 17 Apr 2005 10:02:04 -0700
Subject: Re: Exporting Contacts

Hmm. I just selected the names in the group, and dragged them into an open
TextEdit window, and they came, as one paragraph. Ditto in Excel. Then I
did the same in Word and ran a Find& Replace to get one name per line,
instead of one bunched paragraph. Once I had them one name per line, I was
able to copy and paste them into an untitled group, or into Excel.

Does that help at all? I'm a little confused about what you've tried and
haven't tried.

My group was all set up as just email addresses marked by <address>, so the
Find&Replace was pretty easy--if the names were also there "Name" <address>,
the F&R would be a little more complex. I used Word just because I am most
familiar with that F&R. But I imagine once the data is in a form that can be
manipulated, you should be able to get it to CSV format?

DM
Click to expand...
Click to expand...
 
Top