Re: Address Book Sorting

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Below is a workaround for displaying Address Book contacts in "Last, First"
format by Paul Berkowitz.

----------------------
You can't [display in Last, First format]. Do note that the Name column
nevertheless _sorts_ by Last Name, not First Name.

You could copy LastName FirstName into the Nickname field or a custom field,
and then sort by that. You can also drag that column to the far left
(after making it visible in View/Columns) if you wish.

Transferring all the names in reverse order can be done easily by
AppleScript.

tell application "Microsoft Entourage"
set allContacts to every contact
repeat with aContact in my allContacts
tell aContact
set {fName, lName} to {first name, last name}
if fName ? "" and lName ? "" then
set reverseName to lName & " " & fName -- or:
--set reverseName to lName & ", " & fName -- with comma
else if fName ? "" or lName ? "" then
set reverseName to lName & fName
else if company ? "" then
set reverseName to company
else if (every email address) ? {} then
set reverseName to default email address
else
set reverseName to ""
end if
set its nickname to reverseName -- or:
-- set its custom field three to reverseName -- or whichever
end tell
end repeat
beep
activate
display dialog "All done!" buttons {"OK"} default button 1 with icon 1
end tell

You can run this from Script Editor if you wish (no need to save it.) If you
want a comma between last name and first, remove the first "--" in front of
that line with comma and insert "--" before the preceding line. Similarly if
you want to use a custom field and not the nickname, remove the "--" in
front of the custom view line and insert it before the nickname line (or
just remove that line). You can change the "three" to anything from "one"
through "eight".
----------------------

Be warned that Custom Fields are not indexed and as a result they do not
sort as speedily as other fields.

On 11/22/05 6:34 AM, in article BFA94D8B.7D11%monomeeth@xxxxxxxxxxxxxx,
"Monomeeth" <monomeeth@xxxxxxxxxxxxxx> wrote:

> Hello
>
> I want to be able to sort my address book entries by first name and not last
> name. Is this possible? I can't seem to find an option anywhere to set this
> up...
>
> Many thanks,
>
> Joe.
>

--
Mickey Stevens (Microsoft MVP for Office:mac)
PowerPoint FAQ featuring PowerPoint:mac: <http://www.pptfaq.com/>
Entourage Help Page: <http://www.entourage.mvps.org/>

.



Relevant Pages

  • Re: Auto sort in real time
    ... Even though we've been talking about sorting all along, the cells containing ... They're just displaying the contents of column A in the rank of the values ... > Enter this in B1 to sort *descending*: ...
    (microsoft.public.excel.misc)
  • Re: How Much Data to Provide?
    ... is a lot more efficient than either displaying it all on one page or ... I'd also recommend implementing paging at the stored procedure instead ... sort the data - my way of thinking is if someone sorts the data and then ... Customer Type, and user wants to sort by Customer Type Description ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Unsort a valuelist
    ... valuelist regardless of how I enter them in the field. ... The only way sort a value list in a different order is to use a second ... The only problem is that these second field values are also displayed ... field on the layout grabs the related ID, while displaying the related name. ...
    (comp.databases.filemaker)
  • Re: Any way to view Contacts differently?
    ... You could copy LastName FirstName into the Nickname field or a custom field, ... sort as speedily as other fields. ... > Ken Ray ...
    (microsoft.public.mac.office.entourage)
  • Re: Adressbook
    ... The Address Book should sort by Last Name if you click the name column ... In Entourage 2004, you must launch the Microsoft Database Utility. ... Database Utility separately; ... You could copy LastName FirstName into the Nickname field or a custom field, ...
    (microsoft.public.mac.office.entourage)