[Caleb Williams]

As part of my job, I have been assisting my boss using Word's mail merge.
While the basic functions I understand, I have an advanced question.

Is it possible to group mail merge records with a given condition (In my
case, people who's Last Names start with the same letter) and then move on to
the next page and do the next condition (the next letter)

[Doug Robbins - Word MVP]

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default...b;en-us;211303


http://www.knowhow.com/Guides/Compou...poundMerge.htm


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

"Caleb Williams" Caleb wrote in message
...
As part of my job, I have been assisting my boss using Word's mail merge.
While the basic functions I understand, I have an advanced question.

Is it possible to group mail merge records with a given condition (In my
case, people who's Last Names start with the same letter) and then move on
to
the next page and do the next condition (the next letter)

[Graham Mayor]

For a cheap and cheerful version you could setup a merge document to do the
pages one at a time, by using ASK, REF and SKIPIF fields eg a directory
merge containing the following:

{ ASK bChoice "Enter start letter" \o }{ SKIPIF { MERGEFIELD Last_Name }
"{REF bChoice \*Upper }*" }{ MERGEFIELD Last_Name }

will print a list of last names beginning with whatever start letter you
respond to the ask field at the start of the merge.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Doug Robbins - Word MVP wrote:
See the "Group Multiple items for a single condition" item on fellow
MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default...b;en-us;211303


http://www.knowhow.com/Guides/Compou...poundMerge.htm



"Caleb Williams" Caleb wrote in
message ...
As part of my job, I have been assisting my boss using Word's mail
merge. While the basic functions I understand, I have an advanced
question. Is it possible to group mail merge records with a given
condition
(In my case, people who's Last Names start with the same letter) and
then move on to
the next page and do the next condition (the next letter)

[Caleb Williams]

Thanks Doug, I have printed out the links you gave me and I will look into
them tomorrow when I get to work. I'll let you know how it goes.

"Doug Robbins - Word MVP" wrote:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default...b;en-us;211303


http://www.knowhow.com/Guides/Compou...poundMerge.htm


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

"Caleb Williams" Caleb wrote in message
...
As part of my job, I have been assisting my boss using Word's mail merge.
While the basic functions I understand, I have an advanced question.

Is it possible to group mail merge records with a given condition (In my
case, people who's Last Names start with the same letter) and then move on
to
the next page and do the next condition (the next letter)

[Caleb Williams]

Thanks for the response, but this is designed to be as automated as possible
so that my current boss can run this mailmerge when I leave.

If all else fails though, I have printed out your solution and will use it
as a last resort.

"Graham Mayor" wrote:

For a cheap and cheerful version you could setup a merge document to do the
pages one at a time, by using ASK, REF and SKIPIF fields eg a directory
merge containing the following:

{ ASK bChoice "Enter start letter" \o }{ SKIPIF { MERGEFIELD Last_Name }
"{REF bChoice \*Upper }*" }{ MERGEFIELD Last_Name }

will print a list of last names beginning with whatever start letter you
respond to the ask field at the start of the merge.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Doug Robbins - Word MVP wrote:
See the "Group Multiple items for a single condition" item on fellow
MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default...b;en-us;211303


http://www.knowhow.com/Guides/Compou...poundMerge.htm



"Caleb Williams" Caleb wrote in
message ...
As part of my job, I have been assisting my boss using Word's mail
merge. While the basic functions I understand, I have an advanced
question. Is it possible to group mail merge records with a given
condition
(In my case, people who's Last Names start with the same letter) and
then move on to
the next page and do the next condition (the next letter)