Print a full page of labels for each person

[Rich W]

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,

 

[Graham Mayor]

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.

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


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

 

[Doug Robbins - Word MVP]

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.

--
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]

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 ?

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


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

 

[Rich W]

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