 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / November 2004Problem merging to labels - repeating data
I'm trying to merge address labels from an Excel list, but when I view or merge the data I get records 1-16 on page 1, 2-17 on page 2, 3-18 on page 3 etc. I'm using XP SR2 & Office XP SP3. Anybody any ideas what the problem might be? TIA Paul It sounds as though you are not completing the merge, but viewing the merge source document. Merge to a new document or the printer.  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I'm trying to merge address labels from an Excel list, but when I view > or merge the data I get records 1-16 on page 1, 2-17 on page 2, 3-18 [quoted text clipped - 7 lines] > > Paul Thanks for your reply - I did merge to a new document & got 81 pages - there are 81 records in the list. I noticed than in each label the "Propogate" command had inserted a "Next Record" field before the first line - could this be anything to do with it? Paul > It sounds as though you are not completing the merge, but viewing the merge > source document. Merge to a new document or the printer. [quoted text clipped - 10 lines] > > > > Paul A label merge should have a Next Record field in each label except the first. This is what tells the merge to select the next record for the following label. Frankly it is difficult to see why you have 81 pages for 81 records. You should have 81 divided by the number of labels on the page. It might be a plan to check out your method with the following tutorial: http://www.gmayor.com/mail_merge_labels_with_word_xp.htm -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Thanks for your reply - I did merge to a new document & got 81 pages - > there are 81 records in the list. [quoted text clipped - 29 lines] >>> >>> Paul |
Reply to this Message |
 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.