Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
How to print a full sheet of labels for each person on a list
How do I print a full sheet of labels for each person on a list of about 200
names? I have Office XP. My list of names is in Access. I have tried doing a regular mail merge in Word, but I can only get 1 label for each name on my list. I am using Avery 5167/5267 labels--80 per sheet. Is there an automatic way to do this? |
#2
|
|||
|
|||
Create the label merge, then change the document type from label to form
letter from the merge toolbar and remove any NEXT fields from the labels, then merge. See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm Alternatively use New document option from the envelope/label wizard dialog, which will give you a blank sheet of labels. Use this as the basis for a form letter merge. Put your fields in the first label, then select the content of that cell and copy to the clipboard. Select the whole table and paste the clipboard content. Merge the resulting document. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Powell@BCC wrote: How do I print a full sheet of labels for each person on a list of about 200 names? I have Office XP. My list of names is in Access. I have tried doing a regular mail merge in Word, but I can only get 1 label for each name on my list. I am using Avery 5167/5267 labels--80 per sheet. Is there an automatic way to do this? |
#3
|
|||
|
|||
THANKS!!!
I was able to use your alternate suggestion and make it work. I've been pulling my hair out for a week trying to make this work. Thanks again for responding. Valerie Powell@BCC "Graham Mayor" wrote: Create the label merge, then change the document type from label to form letter from the merge toolbar and remove any NEXT fields from the labels, then merge. See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm Alternatively use New document option from the envelope/label wizard dialog, which will give you a blank sheet of labels. Use this as the basis for a form letter merge. Put your fields in the first label, then select the content of that cell and copy to the clipboard. Select the whole table and paste the clipboard content. Merge the resulting document. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Powell@BCC wrote: How do I print a full sheet of labels for each person on a list of about 200 names? I have Office XP. My list of names is in Access. I have tried doing a regular mail merge in Word, but I can only get 1 label for each name on my list. I am using Avery 5167/5267 labels--80 per sheet. Is there an automatic way to do this? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Only first sheet of labels will print from MailMerge | Mailmerge | |||
How do you print on a partial sheet of labels in MS Word 2000? | Microsoft Word Help | |||
Printing a full page of labels using Mail Merge fields | Microsoft Word Help | |||
Print multiple mailing labels in "middle" of a sheet using Mailmer | Mailmerge | |||
print labels only | Microsoft Word Help |