Mail merge from Access

[C. O'Connor]

I’m doing quite a large mail merge from an Access
datasource. I have my information sorted in Access the way
I want to Mail Merge to print out, however the mail merge
persists in arranging the information in another way (in
numerical order by one of the number columns). What am I
doing wrong?

[Beth Melton]

You need to specify how you want the records to be sorted in Word.
Access is just sending Word the raw data.

How you sort the merge results depends on the version of Word you are
using. If using Office XP then you'll find the sort capability in the
Mail Merge Wizard on Step 3 (I think), where you are presented with a
list of recipients. You then click the column headings to change the
sort order.

In previous versions go to Tools/Mail Merge and select the Query Options
command.

~~~~~~~~~~~~~~~~~~
Beth Melton