 |
 | 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 2004Can I print a sheet of labels for each record of a mail merge?
I have a data source of names / address. (several hundred) One record for each customer. How can I use mail merge to print one sheet of labels for each record? Thanks much. Just remove the <<Next Record>> field from all of the labels on the sheet, then execute the merge. You will then get what you want.  SignaturePlease respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP >I have a data source of names / address. (several hundred) > One record for each customer. > How can I use mail merge to print one sheet of labels for > each record? > Thanks much. hi, i had this problem before too. what you have to do is in your mail merge main document, after each record (w/ its given merge fields in place) insert the word field "next record" from the mail merge toolbar. you insert this field afer each record. it'll merge each individual label on one sheet. >-----Original Message----- >I have a data source of names / address. (several hundred) [quoted text clipped - 3 lines] >Thanks much. >. No it won't! It will put one record to a label and skip each every other record in your data file. A label merge inserts next record fields at the beginning of each label. Your suggestion would add a second. Next record means exactly that! What it requires, as Doug has said is to *remove* the next record fields. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > hi, i had this problem before too. what you have to do is > in your mail merge main document, after each record (w/ [quoted text clipped - 11 lines] >> Thanks much. >> .
|
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.