Can I print a sheet of labels for each record of a mail merge?

[Dave]

I have a data source of names / address. (several hundred)
One record for each customer.
How can I use mail merge to print one sheet of labels for
each record?
Thanks much.

 

[Doug Robbins]

Just remove the <<Next Record>> field from all of the labels on the sheet,
then execute the merge. You will then get what you want.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[David]

hi, i had this problem before too. what you have to do is
in your mail merge main document, after each record (w/
its given merge fields in place) insert the word
field "next record" from the mail merge toolbar. you
insert this field afer each record. it'll merge each
individual label on one sheet.

 

[Graham Mayor]

No it won't! It will put one record to a label and skip each every other
record in your data file. A label merge inserts next record fields at the
beginning of each label. Your suggestion would add a second. Next record
means exactly that! What it requires, as Doug has said is to *remove* the
next record fields.

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


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