Alphabetize in a Data Merge

[Rich]

I am in the process of putting together an address label document in
Word (Office 2004 for Mac) using my Entourage Address book. When I do
the merge, the records do not come up in alphabetical order. Going to
Office Help I searched "alphabetize" and found the following:

1. Set up a data merge.
2. If you don't see the Data Merge Manager, click anywhere in the main
document, and then, on the Tools menu, click Data Merge Manager.
3. Click Query Options under Merge, and then click the Sort Records
tab.
4. Click at least one data field, and then select a sort order.

OK. Only problem is THERE IS NO SORT RECORDS TAB there. What gives?
Anybody know how to get these records to sort? When I press Query
Options and list mail recipients by category, they come up in the label
document in an order that appears to be completely random. When I list
mail recipients by complete record, they come up in alphabetical order
by FIRST name.

I would appreciate any help.

Thanks

Rich Tolsma

 

[Daiya Mitchell]

No help to give, but I'm seeing the same thing you are. And clicking on
Company to sort by that does not really work at all, or it just ignores the
blank fields. Nor can I get Table | Sort to sort the labels after creation.

 

[Paul Berkowitz]

Instead of using the Office Address Book as your data source, first export
all contacts from _Entourage_ via File/Export/Contacts.

Open the resulting tab-delimited text file in Excel.

Use Excel's Sort feature (Data menu) to sort by Lat Name. Save (as Excel
file .xls or again as tab-.txt, it doesn't matter).

Then in Word, choose this Excel file as your data source.

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

 

[Rich]

Thanks for the assistance. Seems a rather roundabout way to do it
though. When I was using "Now Up To Date and Now Contact" it was a much
simpler process.

Rich