 |
 | 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 / June 2004using 1/2 page of labels for each record
I want to print 6 labels for each record that I have. Since I'm using sheet with 12 labels per page, I would like to print 6 of each label on a page. The problem is that when I look at how it has merged, it always repeats the 2nd record again on the top of the next page. In essence, I have recipient one and two on page one, recipient two and three on page two, recipient three and four on page three, ect. How do I get the labels to merge so that recipient one and two are on page one, recipient three and four are on page 2, etc. Christie Hi Christie, Assuming that you have a label type mailmerge main document, you should have a <<Next Record>> before the first merge field in only the sixth label on the sheet. It also sounds like you may not actually be executing the merge, but just stepping through the records with the mail merge main document active on the screen. You must execute the merge either to a new document or directly to the printer. Doing it to a new document first will allow you to check before printing.  SignaturePlease post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP > I want to print 6 labels for each record that I have. Since I'm using sheet with 12 labels per page, I would like to print 6 of each label on a page. The problem is that when I look at how it has merged, it always repeats the 2nd record again on the top of the next page. > In essence, I have recipient one and two on page one, recipient two and three on page two, recipient three and four on page three, ect. > > How do I get the labels to merge so that recipient one and two are on page one, recipient three and four are on page 2, etc.? > > Christie Hi Doug Thanks for the info - this worked Christie |
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.