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

--
Peter Jamieson
http://tips.pjmsn.me.uk

"CCWMC" wrote in message
...
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

[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

"Peter Jamieson" wrote in message
...
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.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"CCWMC" wrote in message
...
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