Sorting Merged Access Data in Word

[CCWMC]

When I merge from Access to a lWord doc, the individual pages/letters
(actually called "sections") seem to be arranged randomly. I'd like to have
the letters print in alphabetical order (by name of recipient). How do you
control the sorting (or the order in which "sections" will print) when doing
a mail merge?
BTW: I'm using an older Office: v. 9.0
With Thanks,
CC

 

[Peter Jamieson]

Are you initiating the merge via Access->Tools->Office links...->(whatever),
or from Word, using a mail merge main document that is connected to an
Access table or query, or some other approach? (It may not be obvious to you
what is happening if someone else has set up Access macros or VBA code to do
this stuff)

Broadly speaking, if you are starting from Word, it's important that you
connect to an Access query that explicitly orders the records in the
sequence you need. Otherwise, you cannot guarantee a particular seqeunce. If
you are starting from one of the Access office Links, I suspect the same
thing is true but it's not familiar territory for me-let us know if that is
the case, and perhaps you could also find out whether the Access query used
has an ORDER BY clause.

 

[Doug Robbins - Word MVP]

What ever way, the sorting should be done in Access.

--
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