I am trying to print address labels, but when I do I am getting a whole sheet per record, but want a continuous sheet with multiple records , what am I doing wrong? Avery 8160 has 30 labels per sheet, and I have 56 records. I am getting 56 sheets, one for each record in the spreadsheet.
Have you checked the “Distribute” setting? When you start the Labels page check this.
File>New>Labels>Option tab then under the Distribute header it should be marked as Entire Page.
[When I do mail merge, I nearly always print to file, then print that file. Saves lots of label sheets. If you aren’t doing this already, when you go to print your Labels sheet and it asks about printing a form letter, say Yes but then select Output as File and Save Merged Document using Save as Single Document.]
1 Like
Thank you , I figured out what I was doing wrong.
It’s always good to let no one know what you did wrong and what you did to solve it…
2 Likes
Actually I found a video on YouTube that explained it well. I was trying to make it to hard.
Of course - and everybody should know the facts anyway and smell the irony.
But they simply won’t understand.