How do I sort categories to use outside of Entourage?

J

John_M

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Email Client: imap

I would like to sort contacts by category and send that list to Excel for a mail merge. For example, I have a category called "mail list" and I want just those contact to export. And, to export all my contacts and be able to sort them by category so I can send my assistant just certain contacts for her work.
 
M

Michel Bintener

You can filter your contacts by category and then export them as .vcf files
simply by selecting them all and dragging them to the desktop.
Alternatively, you could use AppleScript to write all your category names
into one of the custom fields; that way, the category names will be
maintained if you export your contacts as a text file (File>Export). I don't
know who wrote this script, but I assume it was one of the MVPs:

tell application "Microsoft Entourage"
set MyContacts to every contact
set AppleScript's text item delimiters to {";"}
repeat with OneContact in MyContacts
tell OneContact
try
set CategoryList to category of OneContact
repeat with i from 1 to (count CategoryList)
set OneCategory to item i of CategoryList
set item i of CategoryList to name of OneCategory -- or
ID
end repeat
set MyCategory to CategoryList as Unicode text
end try
set custom field eight to MyCategory
end tell
end repeat
set AppleScript's text item delimiters to {""} -- restore
activate
beep
display dialog "Done!"
end tell

Open ScriptEditor, copy/paste the above script and save it. See here for
more details on the use of AppleScript in Entourage:

<http://www.entourage.mvps.org/script/index.html>

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Email Client: imap

I would like to sort contacts by category and send that list to Excel for a
mail merge. For example, I have a category called "mail list" and I want just
those contact to export. And, to export all my contacts and be able to sort
them by category so I can send my assistant just certain contacts for her
work.

--
Michel Bintener
Microsoft MVP
Office:mac (Entourage & Word)

*** Please always reply to the newsgroup. ***
 
D

Diane Ross

I would like to sort contacts by category and send that list to Excel for a
mail merge. For example, I have a category called "mail list" and I want just
those contact to export. And, to export all my contacts and be able to sort
them by category so I can send my assistant just certain contacts for her
work.

Here is another option to create a tab delimited file for a specific
category;

Import Export Contacts
<http://www.entourage.mvps.org/import_export/contacts.html#group>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top