View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
unable2merge unable2merge is offline
external usenet poster
 
Posts: 2
Default Word is printing multiple copies of each record on a label sheet

I am making name badges for a conference in Word 2007. When I preview the
mail merge and run the mail merge Word prints an entire sheet of labels for
each record I have in my database (95 names = 95 sheets!). How do I make this
stop? I only need 1 label per record so that I have 6 different names per
sheet.

Additional Info that might be pertinent to resolving the problem:
I downloaded the template from avery.com because it was not available in the
Word table menu. It's a table with 6 squares, each 3"x4".

I added the 4 mail merge fields to each of the 6 boxes on the label page.
Those fields are as follows:
First Name Last Name
Title
Company

I selected preview mail merge and get 95 pages with each page having one
record 6 times. I also selected finish & merge and it does the same thing 95
pages, 1 record per page.