The Address Book should sort by Last Name if you click the name column
header, even though it displays the names in the "First Last" format. If it
doesn't, that could be a sign of database corruption. Try rebuilding the
database.
In Entourage 2004, you must launch the Microsoft Database Utility.
1. Launch Entourage, holding down the ³Option² key. Or, launch the
Database Utility separately; it is located in HD/Applications/Microsoft
Office 2004/Office/.
2. If you are prompted, allow the Database Utility to quit open Office
applications.
3. Once the Database Utility is open, select your identity from the list at
the top.
4. Click the ³Rebuild Database² button, and click ³Continue.²
Below is a workaround for displaying Address Book contacts in "Last, First"
format by Paul Berkowitz.
----------------------
You can't. 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".
