Mail Merge Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Caleb Williams - 28 Aug 2006 00:08 GMT

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)

Reply to this Message

Doug Robbins - Word MVP - 28 Aug 2006 04:23 GMT

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

Signature

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

> 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.
[quoted text clipped - 3 lines]
> to
> the next page and do the next condition (the next letter)

Reply to this Message

Graham Mayor - 28 Aug 2006 07:06 GMT

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.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> See the "Group Multiple items for a single condition" item on fellow
> MVP Cindy Meister's website at
[quoted text clipped - 14 lines]
>> then move on to
>> the next page and do the next condition (the next letter)

Reply to this Message

Caleb Williams - 28 Aug 2006 22:26 GMT

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.

> 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
[quoted text clipped - 24 lines]
> >> then move on to
> >> the next page and do the next condition (the next letter)

Reply to this Message

Caleb Williams - 28 Aug 2006 22:24 GMT

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.

> See the "Group Multiple items for a single condition" item on fellow MVP
> Cindy Meister's website at
[quoted text clipped - 14 lines]
> > to
> > the next page and do the next condition (the next letter)

Reply to this Message