Print a full page of labels for each person

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rich W - 18 Jun 2007 15:12 GMT

I am trying to print a full page of the same labels for each person. My data
source is Excel. So far I can only come up with having 20 (a full page) of
occurances of the same person in the spreadsheet. I have 100's of people. Is
there a way of having the merge print a full page for each person without
working in the datasource?
Thanks,

Signature

Rich W

Reply to this Message

Graham Mayor - 18 Jun 2007 15:37 GMT

Start the label merge as normal
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm and then when you
get to the point where you add your fields into the first label, before
propagating, change the document type from mailing label to letters.
Complete that first label as normal, then copy the label and select the
whole table and paste. DO NOT ADD ANY NEXT RECORD FIELDS!!!This will paste
that label to each of the others. Merge to a new document or the printer.

Alternatively propagate the labels and use replace to remove all the Next
record fields ie press ALT+F9 to toggle the display search for
^d NEXT
replace with nothing
then change the document type to letters so that you don't accidentally put
back the next record fields. Toggle the display again ALT+F9 and merge.

Signature

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

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

> I am trying to print a full page of the same labels for each person.
> My data source is Excel. So far I can only come up with having 20 (a
> full page) of occurances of the same person in the spreadsheet. I
> have 100's of people. Is there a way of having the merge print a full
> page for each person without working in the datasource?
> Thanks,

Reply to this Message

Doug Robbins - Word MVP - 19 Jun 2007 12:59 GMT

Graham,

When you select a label type mail merge main document and then select the
type of label, the <<Next Record>> fields, while not initially visible are
already in each of the cells of table other than the first cell.

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

> Start the label merge as normal
> http://www.gmayor.com/mail_merge_labels_with_word_xp.htm and then when
[quoted text clipped - 19 lines]
>> page for each person without working in the datasource?
>> Thanks,

Reply to this Message

Graham Mayor - 19 Jun 2007 13:31 GMT

True - but it doesn't affect the basic premise. The quoted web page also
covers the issue of starting from a label template, which will not have next
record fields. Even when set as a label merge such a document does not have
Next fields automatically inserted. It is only when you start the whole
shebang as a label merge and pick the document from the label wizard task
pane that you get Next fields added by default.

Hopefully the OP will get the point that it is the Next fields that are not
wanted ? :)

Signature

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

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

> Graham,
>
[quoted text clipped - 34 lines]
>>> full page for each person without working in the datasource?
>>> Thanks,

Reply to this Message

Rich W - 27 Jun 2007 14:30 GMT

Thanks, I got it to work. (after about 20 tries). I wouldn't have come close
without your help.

Signature

Rich W

> True - but it doesn't affect the basic premise. The quoted web page also
> covers the issue of starting from a label template, which will not have next
[quoted text clipped - 44 lines]
> >>> full page for each person without working in the datasource?
> >>> Thanks,

Reply to this Message

Rate this thread: