[StephenW]

Actually, that is an option I can not use. I can't be sure if the user has
Access or knows how to use it. This mail merge is part of a macro set that
is used first to FTP the data file from UNIX to Windows then used in the form
files. I have a form containing buttons, one of which brings up the
MailMerge Query Option diaolog box where the user should be able to sort the
data how he wants. The users are all over my State and sometimes want to
print these documents in different orders. Is there something different in
the way that Word is sorting the special characters, periods and commas, then
in either Excell or Access?

"Doug Robbins - Word MVP" wrote:

Put the data into Access and use a query in Access to sort it the way you
want it and as the datasource for the mailmerge.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"StephenW" wrote in message
...
I have a client using a mail merge macro I wrote. One option is to use the
reciepant sort of the data source. The sort works fine if the user
chooses
simple fileds like Last_Name or District_Name. But the user wants these
sorted by parcel numbers. These are actual property parcel numbers from a
Tax Claim Bureau so that they are formatted in strange ways, like:
01,002.-098L.-000
01,002.-098M.-000
02,002.-095B.-000
03,003.-077..-001
01,003.-051..-002

When I try the sort, it comes out in a strange order. At first it almost
looks like descending, even though I have ascending choosen, but after
about
three records it starts going all over the place. I've taken this data
file
in Excel and Access and both sort these numbers correctly. Only Word
seems
to have the problem. Does any have any suggestions?