Creating mutliple labels for each mail merge recipient

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Russell - 24 May 2005 16:26 GMT

Hello All,

I work at a help desk and need use mail merge to create lables to forward my
residents mail during the summer. I have created an Excel list to act as the
data base. Usually I need to create only one label per recipient howeve there
are times when I may need to create multiple lables for one recipient, and
then single lables for all other recipeints in the data base. So far I have
been cutting and pasting the extra copies but is there a way to automate the
process so I could print say, three lables in a row for one recipient and
then one each for the next recipient and so on. Any assistance you may give
would be great.

Reply to this Message

Graham Mayor - 24 May 2005 18:05 GMT

Start with a standard mail merge to labels then remove the {next} fields
from as many labels as you need duplicates - it is the NEXT field that reads
the next record.

Signature

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

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

> Hello All,
>
[quoted text clipped - 8 lines]
> then one each for the next recipient and so on. Any assistance you
> may give would be great.

Reply to this Message

Doug Robbins - 24 May 2005 18:43 GMT

It's probably easier to open the data source and copy and paste the record
for which you want multiple labels so as the make multiple copies of that
record.

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

> Hello All,
>
[quoted text clipped - 13 lines]
> give
> would be great.

Reply to this Message