I am doing a mail merge onto a 20 label per sheet 81/2 x 11 paper. Data source is an Excel spreadsheet and recipient list shows all rows ticked. When I look at mail merge preview, it shows only one label per sheet.
one label per sheet-mail merge woe presview shows one label instead of 20
Thumbs-up points: 
MultiQuote
#2
Posted 2010-07-30 13:55
It will complete the rest when you finish the "Wizard". That is one reason that I dislike "Wizards" by trying to make things easy they can be miss-leading and are rarely flexible.
#3
Posted 2010-07-30 13:57
What version of Word are you using? And did you use the wizard to create your labels? If you did then there is a fill down step that creates all the other 19 labels per sheet with the appropriate field codes for the merge. Try doing a merge to a new document and see if you get what you expected.