I'm trying to create mailing labels in Access. I'm having two issues with them.
First, I would like to sort the labels by Division, then by Department and finally by Employee. This I was able to do successfully, but now I want to group them by their Department with each department starting a new page. For example I have 9 people in one department and 12 people in another. I am using labels that contain 6 per sheet. But, when I view the report, even after I've followed the grouping instructions, I can't seem to force a new page.
Second, I am using Avery 5164 labels for this project and would like to print landscape as opposed to portrait. I've used the following settings:
Label: Custom Label
Dimension: 4.00 x 3.33
Number Across: 3
I am attaching the screen shot of the label measurements and the page properties.