Mail Merge Question

[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/cindymeister/mergfaq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303


http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.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

 

[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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

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

 

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