Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2005

Tip: Looking for answers? Try searching our database.

Duplicate lables created with Mail Merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
trekguy1 - 03 Jun 2005 01:55 GMT
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).
Graham Mayor - 03 Jun 2005 05:27 GMT
See where what you are doing differs from
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> 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
[quoted text clipped - 12 lines]
> How do I get 74 labels, for the 74 different rows on my Excel
> worksheet? Help!?! (and thank you).
trekguy1 - 03 Jun 2005 17:55 GMT
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!

> See where what you are doing differs from
> http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
[quoted text clipped - 15 lines]
> > How do I get 74 labels, for the 74 different rows on my Excel
> > worksheet? Help!?! (and thank you).
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.