Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Entourage / October 2008



Tip: Looking for answers? Try searching our database.

How do I sort categories to use outside of Entourage?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John_M@officeformac.com - 09 Oct 2008 06:13 GMT
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 - 09 Oct 2008 06:33 GMT
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>

On 09/10/08 7:13, in article 59b5c1db.-1@webcrossing.caR9absDaxw,

> Version: 2008
> Operating System: Mac OS X 10.5 (Leopard)
[quoted text clipped - 6 lines]
> them by category so I can send my assistant just certain contacts for her
> work.

Signature

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

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

Barry Wainwright - 09 Oct 2008 07:10 GMT
> I don't know who wrote this script, but I assume it was one of the MVPs:

It looks like one of Corentin's.

Signature

Barry Wainwright
Microsoft MVP

Diane Ross - 09 Oct 2008 23:38 GMT
> 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>

Signature

Diane

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.