J
Jon_in_San_Diego
While posting a question, I figured out how to make this work! Hope it helps
you, too.
OK, I've read the posts and tried several things, but I STILL get 1 record
30 times on 1 sheet of labels, avery 5160. - I have the template set up so
that I only see 1 label on the screen. I merge to the printer and get 30
labels exactly the same.
After selecting the Excel worksheet, I add the fields, then Print Merge,
which is the same as hitting "Print." The Print box comes up and here's the
key: Print Options: "Multiple Pages per Sheet." (voila) - the default (it
came up automatically) was the other box, "multiple copies per sheet." That
was the problem that produced 30 records per sheet of labels.
Hope that helps you, too.
you, too.
OK, I've read the posts and tried several things, but I STILL get 1 record
30 times on 1 sheet of labels, avery 5160. - I have the template set up so
that I only see 1 label on the screen. I merge to the printer and get 30
labels exactly the same.
After selecting the Excel worksheet, I add the fields, then Print Merge,
which is the same as hitting "Print." The Print box comes up and here's the
key: Print Options: "Multiple Pages per Sheet." (voila) - the default (it
came up automatically) was the other box, "multiple copies per sheet." That
was the problem that produced 30 records per sheet of labels.
Hope that helps you, too.