I have an excel spreadsheet with a list of 93 names and addresses. All of the columns are properly labled When I create the mail merge doc, it starts a new page for each line in the spreadsheet. So I end up with 93 pages. Page 1 is the first line on the spreadsheet then 29 more labels. Page 2 is the second line then 29 more labels. Page 3 is the third line and 29 more labels.



I should be getting 3 pages of labels, instead I get 93. The last page has 1 label, the last one in the list.

I have attached a sample of how the merge fields need to be set up. I hope this helps.

Attached Files

labels.docx (12.5 KB, 7 views)