(EntourageX) Exporting a group from Contact list

C

Colin Fox

I have a group within my contacts list that I would like to send to all
members of the group so they can contact each other.

Exporting this to Excel would be best, but I can't figure out how, nor does
the Help function give much guidance.

Is this possible?

Many thanks, Colin
 
D

Dave Cortright

I have a group within my contacts list that I would like to send to all
members of the group so they can contact each other.

Exporting this to Excel would be best, but I can't figure out how, nor does
the Help function give much guidance.

Is this possible?

Drag and drop.
 
C

Colin Fox

Drag and drop.

That was a good thought, but did not really work. Into excel, it just put
the addresses in one big line.
In word, it made it one big paragraph.
Neither copied the names, only the addresses.
 
P

Paul Berkowitz

Ah, so it does.

Could you please not change the subject of a thread when replying, Colin
(and others)? It makes for a lot of redundant work. Most regulars sort
messages by threads and look to see if an answer has been supplied before
replying oneself. That's impossible if you change the subject. (Leave
spelling errors alone too.) Thanks.

I do get a <> after a group member's name, but that's OK. Regular contacts
with name and address come across just fine this way.

--
Paul Berkowitz
MVP Entourage
Entourage FAQ Page: <http://www.entourage.mvps.org/toc.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 Entourage you are using - 2001 or X.
It's often impossible to answer your questions otherwise.



From: Colin Fox <[email protected]>
Newsgroups: microsoft.public.mac.office.entourage
Date: Tue, 20 Apr 2004 14:49:38 -0300
Subject: Re: (EntourageX) Exporting a group from Contact list---My Mistake

I was hightlighting all the names in the group rather than dragging the
group name title to the spreadsheet.
You are correct, it works just fine.

Many thanks, Colin
 
B

Barry N. Wainwright

I have a group within my contacts list that I would like to send to all
members of the group so they can contact each other.

Exporting this to Excel would be best, but I can't figure out how, nor does
the Help function give much guidance.

Is this possible?

Many thanks, Colin

Yes, with this script:

-- Copy Group Entries to Clipboard v1.0
-- Barry Wainwright 22/04/2004
-- An applescript of Microsoft Entourage
-- This script will put all the entries of a selected group
-- on the clipboard as Tab-Delimited Text
-- Just select a group in the address book listing and run the script.

tell application "Microsoft Entourage"
try
set theGroup to item 1 of (get selection)
on error
display dialog "Please select a group in the address book and run
the script again" buttons {"OK"} default button 1 with icon stop
return -99
end try
if class of theGroup is group then
set exportList to {"Group: " & name of theGroup}
set groupEntries to content of every group entry of theGroup
repeat with anEntry in groupEntries
copy {display name of anEntry & tab & address of anEntry} to end
of exportList
end repeat
set {oldDelims, AppleScript's text item delimiters} to
{AppleScript's text item delimiters, return}
set the clipboard to exportList as text
set applescript¹s text item delimiters to oldDelims
else
display dialog "Please select a group in the address book and run
the script again" buttons {"OK"} default button 1 with icon stop
end if
end tell




Save the script as a compiled script & put it in the ŒEntourage Script Menu
Items¹ folder in your ŒMicrosoft User Data¹ folder. The script can be
manually run from the menu.



--
Barry Wainwright
Microsoft MVP (see http://mvp.support.microsoft.com for details)
Seen the Entourage FAQ pages? - Check them out:
<http://www.entourage.mvps.org/toc.html>

Please post responses to this newsgroup. If I ask you to contact me
off-list, remove '.INVALID' from email address before replying.
 
Top