 |
 | 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 / September 2004duplicate records
I'm trying to create labels using mail merge. I downloaded the addresses that I need form the web into a word 2002 document, The fields are separated by tabs and the records are separated by the "enter key". There are about 150 records all together. There are no duplicate records, null records, or null fields. When I merge the 150 records onto the label template, I'm getting lots of duplicates. I don't know why. 120 records (addresses) can fit on a 3 label across by 40 label down sheet . I added a number field for test purposes to the data. Addresses 1 thru 120 fit appear on the first sheet correctly. Then come the repeats. Addresses 2 thru 121 appear on the second sheet. Addresses 3 thru 122 fit on the third sheet, etc. I've tried all different kind of sorts. Nothing seems to work. Anyone have any ideas? Thanks.. My guess is that you haven't completed the merge and are viewing the merge source document - see 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 trying to create labels using mail merge. I downloaded the > addresses that I need form the web into a word 2002 document, The [quoted text clipped - 10 lines] > Anyone have any ideas? > Thanks.. Thanks, but I think that I did everything correctly. I selected an Avery label template from the mail merge wizard and merged the address data onto it. The output looked correct except for all of the duplicates. Dave > My guess is that you haven't completed the merge and are viewing the merge > source document - see [quoted text clipped - 14 lines] >> Anyone have any ideas? >> Thanks.. Did you merge to the printer or a new document? Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Thanks, but I think that I did everything correctly. I selected an > Avery label template from the mail merge wizard and merged the [quoted text clipped - 29 lines] >>> work. Anyone have any ideas? >>> Thanks.. No, that was the problem Thanks! I didn't complete the merge after all. I stopped after I clicked the "view merge" button. When I saw all the duplicates, I thought that there was something wrong. I'm wondering why the "view merge" shows duplicates? Dave > Did you merge to the printer or a new document? > [quoted text clipped - 32 lines] >>>> work. Anyone have any ideas? >>>> Thanks.. That's how the merge source document works - it simply steps through the data one record at a time. You have to complete the merge. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > No, that was the problem Thanks! I didn't complete the merge after > all. I stopped after I clicked the "view merge" button. When I saw [quoted text clipped - 47 lines] >>>>> work. Anyone have any ideas? >>>>> Thanks..
|
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.