How to create duplicate labels with mail merge?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Office 2003, have a SS with addresses, have merged into word to create
mailing labels works fine....I need to create membership labels....2 of the
same address to a row....is there a way to merge the SS into word without
creating duplicate rows in the SS...This is a huge membership list.
 
Try this:

Select a two column label format in Word mail merge.

In first pair of labels enter Name & Address Fields (removing "Next Record"
control field)

In the next (second) pair, keep the "Next Record" control field in the first
label, adding the name & address details; in the second label just put the
name & address details.

Repeat the second format for the rest of the sheet.


HTH
 
It worked!!!! Thank you, thank you, thank you!!!
You have saved me so much time!
Really appreciate it!
Beth :):):)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Problem 1
30 fields each to be checked by 1000 people 2
Deleting zeros when mail merge 2
Labels Wizard 3
Eliminate blank fields in mail merge from Excel to Word 1
Mail Merge Label Problem 2
Excel Address list 4
Combining Rows on a label 1

Back
Top