How to copy 100s of email addresses?

P

Pitch

Working in Entourage 2004.

I thought I knew this program well, but I can't remember if it'll do
this:

I need to grab just the email addresses of about 900 contacts, in order
to paste them into a delimited file (comma, paragraph, tab, etc).

I can isolate the names in my address book because they all have the
same category.

I have tried the File: Export command, but it either exports into a
..rge file that looks to be openable only by Entourage. Or, if I select
the option to "Export to a tab-delimited file", it then exports all
7,200 names in my Address book. I can't find a way to get it only
export those 900 in that one category.

Is there a built-in way to do this, or do I need a script.
 
P

Paul Berkowitz

Working in Entourage 2004.

I thought I knew this program well, but I can't remember if it'll do
this:

I need to grab just the email addresses of about 900 contacts, in order
to paste them into a delimited file (comma, paragraph, tab, etc).

I can isolate the names in my address book because they all have the
same category.

I have tried the File: Export command, but it either exports into a
.rge file that looks to be openable only by Entourage. Or, if I select

the option to "Export to a tab-delimited file", it then exports all
7,200 names in my Address book. I can't find a way to get it only
export those 900 in that one category.

Is there a built-in way to do this, or do I need a script.
Click to expand...

My Export-Import Entourage scripts from

MacScripter.net <http://macscripter.net/scriptbuilders/>

will export just a selection of contacts, or by category, to a text file.

--
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.
 
B

Barry Wainwright

Working in Entourage 2004.

I thought I knew this program well, but I can't remember if it'll do
this:

I need to grab just the email addresses of about 900 contacts, in order
to paste them into a delimited file (comma, paragraph, tab, etc).

I can isolate the names in my address book because they all have the
same category.

I have tried the File: Export command, but it either exports into a
.rge file that looks to be openable only by Entourage. Or, if I select

the option to "Export to a tab-delimited file", it then exports all
7,200 names in my Address book. I can't find a way to get it only
export those 900 in that one category.

Is there a built-in way to do this, or do I need a script.
Click to expand...

If it's just a one-off thing, try the following

In address book view, select the contacts and hit the 'new message to'
button. This will open a new message addresses to all those contacts.

Click in the 'to' address pane, to open the scrolling list of all the
contacts, select one and hit cmd-a to select them all.

Drag the selection to the desktop - a text clipping will be created there of
all the names & addresses.

If you need to do this on a regular basis, then a script could be written...

http://tinyurl.com/9748q

-- Select the contacts and run this script
tell application "Microsoft Entourage"
set theSelection to selection
try
set firstItem to item 1 of theSelection
on error
beep
return
end try
if class of firstItem is not contact then
beep
return
end if
set contactList to {}
repeat with anItem in theSelection
try
copy "\"" & name of anItem & "\" <" & default email address of
anItem & ">" to end of contactList
end try
end repeat
end tell
set {oldTIDs, AppleScript's text item delimiters} to {AppleScript's text
item delimiters, {return}}
set the clipboard to contactList as text
set AppleScript's text item delimiters to oldTIDs
 
Top