Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Duplicate lables created with Mail Merge
I'm using an Excel spreadsheet for my data source, and Word 2002 for my mail
merge. I've been using the Mail Merge Wizard to set up an address block since it's been useful in manipulating the data from my excel spreadsheet. However, in step 4 of the wizard, after I've set up my address block, I've been clicking on either "update all labels" or the "propagate lables" icon on the toolbar (they both seem to do the same thing). Here's my problem: I'm getting duplicate lables. For example, if my Excel list has 74 rows, I get 74 pages of lables. The first page of lables starts with the first name on my Excel list, then on page 2 of the labels, it starts with the second name on my Excel list, and page 3 begins with the third name on my Excel list, and so on. How do I get 74 labels, for the 74 different rows on my Excel worksheet? Help!?! (and thank you). |
#2
|
|||
|
|||
See where what you are doing differs from
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org trekguy1 wrote: I'm using an Excel spreadsheet for my data source, and Word 2002 for my mail merge. I've been using the Mail Merge Wizard to set up an address block since it's been useful in manipulating the data from my excel spreadsheet. However, in step 4 of the wizard, after I've set up my address block, I've been clicking on either "update all labels" or the "propagate lables" icon on the toolbar (they both seem to do the same thing). Here's my problem: I'm getting duplicate lables. For example, if my Excel list has 74 rows, I get 74 pages of lables. The first page of lables starts with the first name on my Excel list, then on page 2 of the labels, it starts with the second name on my Excel list, and page 3 begins with the third name on my Excel list, and so on. How do I get 74 labels, for the 74 different rows on my Excel worksheet? Help!?! (and thank you). |
#3
|
|||
|
|||
THANK YOU!!! Yes, this article had my answer. I ended up having to use
buttons on my toolbar after completeing step 4 in the wizard (so I didn't use the wizard after step 4), but it was an easy fix! "Graham Mayor" wrote: See where what you are doing differs from http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org trekguy1 wrote: I'm using an Excel spreadsheet for my data source, and Word 2002 for my mail merge. I've been using the Mail Merge Wizard to set up an address block since it's been useful in manipulating the data from my excel spreadsheet. However, in step 4 of the wizard, after I've set up my address block, I've been clicking on either "update all labels" or the "propagate lables" icon on the toolbar (they both seem to do the same thing). Here's my problem: I'm getting duplicate lables. For example, if my Excel list has 74 rows, I get 74 pages of lables. The first page of lables starts with the first name on my Excel list, then on page 2 of the labels, it starts with the second name on my Excel list, and page 3 begins with the third name on my Excel list, and so on. How do I get 74 labels, for the 74 different rows on my Excel worksheet? Help!?! (and thank you). |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you view more than one page of lables using mail merge? | Mailmerge | |||
Mail Merge Lables | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
How do I add names to an existing mail merge address book created. | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge |