merging labels

[sandingdude]

here is my situation...i have a spreadsheet of about 100
different products. i created a label in publisher to
merge with this spreadsheet. i am trying to get one record
from that spreadsheet to print on 1 page of labels. the
sheet has 10 labels per sheet. when i go to print one
record on 10 sheets, giving me a total of 100 labels it
wants to just print each individual record. does anyone
have a work around for this?

thanks