Failure to Alphabetize Labels in Mail Merge Document

N

NRoehr

Have been trying to perform a mail merge in Word 2008 (12.1.5) using
my Office Address Book in Entourage. As part of this I am trying to
Filter Recipients using the Query Options dialog that opens when I
click the Options button in the Filter Recipients section of the Mail
Merge Manager.
Despite the fact that I have several categories set up and actively
associated with contacts in Entourage, when I select the option to
list mail merge recipients by Categories my category list always
contains None, Junk and a bunch of check boxes with no description to
the right of them that presumably represent my actual categories.
Further when I select the option to under 6. Complete Merge to Merge
to New Document all my Recipients are listed not in alpha order, which
is what I am trying to do, but in what appears to be the order in
which the contacts were entered into the Office Address Book.

A Microsoft response to this issue I discovered says that this is a
known issue that was discovered recently and is currently in the hands
of Microsoft’s development team. When they have a fix for this issue
it will be released via an update, so keep updating.
In the mean time they have discovered a work-around for this issue.
1. When you get to the point in the merge where you can select the
categories, at the top of the screen you will see a drop down.
2. In the drop down select all records, then choose OK
3. Re-open the merge screen and from the drop down go back to choosing
categories.
4. All categories should now appear.

This work-around succeeds only to list the categories correctly,
however the final label document still appears only in the random
order in which the entries were made in the Office Address Book and
not in alpha order.

How can I fix this final piece and get my labels to be organized in
alphabetical order? – which a logical way of organizing that I would
think is the point of the exercise for many users with lengthy address
label lists.

Thanks.

Nancy
 
C

CyberTaz

You might try using Entourage's File> Export> Contacts to a List (tab
delimited text). You can use the text file as your record source or you can
import the list into Excel & remove the extra fields/columns which will
undoubtedly be there. The Mail Merger Manager's Sort & Filter features
should work fine with either.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
N

NRoehr

Thanks very much. Have tried this and it will only export my entire
address book, not just the CHRISTMAS LIST. How do I get only the
correct 200 out of 500 contacts to export? or be able to export the
entire address book, but sort only the Christmas list in a spread
sheet?
 
C

CyberTaz

I¹m honestly not sure what to tell you ­ I don¹t really merge from the
Office Address Book. I know there are some limitations but you¹ll probably
get more assistance in the Entourage group. I¹ve forwarded you inquiry to
them ­ folks who are regulars there & may be able to help don¹t necessarily
frequent the Word group.

Regards |:>)
Bob Jones
[MVP] Office:Mac
 

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