Mail Merge - how to create duplicate labels for each person entry

Y

yenwei

I have a list of unique names/addresses in Excel. For each single
person/address in Excel, I would like to use Word mail merge to create 6
identical address labels. (1:6 ratio) Is there a way to do so without
having to manually replicate the names/address in Excel?

Thanks for your help!
 
G

Graham Mayor

The simplest method is to merge to a new document and print six copies.
OR
If your label sheet is a multiple of 6 then after propagating the labels
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm remove the next
record fields from the 2nd, 3rd, 4th, and 5th labels then from the 7th,
8th,9th,10th,11th etc. before merging.
OR
Create a new data sheet with 6 copies of each record and merge normally.

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

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Y

yenwei

Thanks, I think solution #2 does the trick for me!!!

I appreciate your speedy reply.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge: Create page of same labels 5
Mail Merge Labels (Word 2007) w/ Excel (2007) 2
duplicate pages in mail merge 4
More problems with Word 2002 mail merge 2
Word 2003 mail merge 3
Mail merge labels 1
Merge Excel to Avery 30607 labels 2
question about formatting labels (mail merge) 2

Top