Print a full page of labels for each person Rich W 6/18/2007 2:12:01 PM I am trying to print a full page of the same labels for each person. My data source is Excel. So far I can only come up with having 20 (a full page) of occurances of the same person in the spreadsheet. I have 100's of people. Is there a way of having the merge print a full page for each person without working in the datasource? Thanks, -- Rich W

Re: Print a full page of labels for each person "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 6/18/2007 2:37:37 PM Start the label merge as normal http://www.gmayor.com/mail_merge_labels_with_word_xp.htm and then when you get to the point where you add your fields into the first label, before propagating, change the document type from mailing label to letters. Complete that first label as normal, then copy the label and select the whole table and paste. DO NOT ADD ANY NEXT RECORD FIELDS!!!This will paste that label to each of the others. Merge to a new document or the printer. Alternatively propagate the labels and use replace to remove all the Next record fields ie press ALT+F9 to toggle the display search for ^d NEXT replace with nothing then change the document type to letters so that you don't accidentally put back the next record fields. Toggle the display again ALT+F9 and merge. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Rich W wrote: [Quoted Text] > I am trying to print a full page of the same labels for each person. > My data source is Excel. So far I can only come up with having 20 (a > full page) of occurances of the same person in the spreadsheet. I > have 100's of people. Is there a way of having the merge print a full > page for each person without working in the datasource? > Thanks,

Re: Print a full page of labels for each person "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 6/19/2007 11:59:22 AM Graham, When you select a label type mail merge main document and then select the type of label, the <<Next Record>> fields, while not initially visible are already in each of the cells of table other than the first cell. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> wrote in message news:eV8B0YbsHHA.3556[ at ]TK2MSFTNGP05.phx.gbl... [Quoted Text] > Start the label merge as normal > http://www.gmayor.com/mail_merge_labels_with_word_xp.htm and then when > you get to the point where you add your fields into the first label, > before propagating, change the document type from mailing label to > letters. Complete that first label as normal, then copy the label and > select the whole table and paste. DO NOT ADD ANY NEXT RECORD FIELDS!!!This > will paste that label to each of the others. Merge to a new document or > the printer. > > Alternatively propagate the labels and use replace to remove all the Next > record fields ie press ALT+F9 to toggle the display search for > ^d NEXT > replace with nothing > then change the document type to letters so that you don't accidentally > put back the next record fields. Toggle the display again ALT+F9 and > merge. > > -- > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham Mayor - Word MVP > > My web site www.gmayor.com > Word MVP web site http://word.mvps.org > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > > Rich W wrote: >> I am trying to print a full page of the same labels for each person. >> My data source is Excel. So far I can only come up with having 20 (a >> full page) of occurances of the same person in the spreadsheet. I >> have 100's of people. Is there a way of having the merge print a full >> page for each person without working in the datasource? >> Thanks, > >

Re: Print a full page of labels for each person "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 6/19/2007 12:31:07 PM True - but it doesn't affect the basic premise. The quoted web page also covers the issue of starting from a label template, which will not have next record fields. Even when set as a label merge such a document does not have Next fields automatically inserted. It is only when you start the whole shebang as a label merge and pick the document from the label wizard task pane that you get Next fields added by default. Hopefully the OP will get the point that it is the Next fields that are not wanted ? :) -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Doug Robbins - Word MVP wrote: [Quoted Text] > Graham, > > When you select a label type mail merge main document and then select > the type of label, the <<Next Record>> fields, while not initially > visible are already in each of the cells of table other than the > first cell. > > "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> wrote in message > news:eV8B0YbsHHA.3556[ at ]TK2MSFTNGP05.phx.gbl... >> Start the label merge as normal >> http://www.gmayor.com/mail_merge_labels_with_word_xp.htm and then >> when you get to the point where you add your fields into the first >> label, before propagating, change the document type from mailing >> label to letters. Complete that first label as normal, then copy the >> label and select the whole table and paste. DO NOT ADD ANY NEXT >> RECORD FIELDS!!!This will paste that label to each of the others. >> Merge to a new document or the printer. >> >> Alternatively propagate the labels and use replace to remove all the >> Next record fields ie press ALT+F9 to toggle the display search for >> ^d NEXT >> replace with nothing >> then change the document type to letters so that you don't >> accidentally put back the next record fields. Toggle the display >> again ALT+F9 and merge. >> >> -- >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> >> Graham Mayor - Word MVP >> >> My web site www.gmayor.com >> Word MVP web site http://word.mvps.org >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> >> >> Rich W wrote: >>> I am trying to print a full page of the same labels for each person. >>> My data source is Excel. So far I can only come up with having 20 (a >>> full page) of occurances of the same person in the spreadsheet. I >>> have 100's of people. Is there a way of having the merge print a >>> full page for each person without working in the datasource? >>> Thanks,

Re: Print a full page of labels for each person Rich W 6/27/2007 1:30:03 PM Thanks, I got it to work. (after about 20 tries). I wouldn't have come close without your help. -- Rich W "Graham Mayor" wrote: [Quoted Text] > True - but it doesn't affect the basic premise. The quoted web page also > covers the issue of starting from a label template, which will not have next > record fields. Even when set as a label merge such a document does not have > Next fields automatically inserted. It is only when you start the whole > shebang as a label merge and pick the document from the label wizard task > pane that you get Next fields added by default. > > Hopefully the OP will get the point that it is the Next fields that are not > wanted ? :) > > -- > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham Mayor - Word MVP > > My web site www.gmayor.com > Word MVP web site http://word.mvps.org > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > > Doug Robbins - Word MVP wrote: > > Graham, > > > > When you select a label type mail merge main document and then select > > the type of label, the <<Next Record>> fields, while not initially > > visible are already in each of the cells of table other than the > > first cell. > > > > "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> wrote in message > > news:eV8B0YbsHHA.3556[ at ]TK2MSFTNGP05.phx.gbl... > >> Start the label merge as normal > >> http://www.gmayor.com/mail_merge_labels_with_word_xp.htm and then > >> when you get to the point where you add your fields into the first > >> label, before propagating, change the document type from mailing > >> label to letters. Complete that first label as normal, then copy the > >> label and select the whole table and paste. DO NOT ADD ANY NEXT > >> RECORD FIELDS!!!This will paste that label to each of the others. > >> Merge to a new document or the printer. > >> > >> Alternatively propagate the labels and use replace to remove all the > >> Next record fields ie press ALT+F9 to toggle the display search for > >> ^d NEXT > >> replace with nothing > >> then change the document type to letters so that you don't > >> accidentally put back the next record fields. Toggle the display > >> again ALT+F9 and merge. > >> > >> -- > >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > >> Graham Mayor - Word MVP > >> > >> My web site www.gmayor.com > >> Word MVP web site http://word.mvps.org > >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > >> > >> Rich W wrote: > >>> I am trying to print a full page of the same labels for each person. > >>> My data source is Excel. So far I can only come up with having 20 (a > >>> full page) of occurances of the same person in the spreadsheet. I > >>> have 100's of people. Is there a way of having the merge print a > >>> full page for each person without working in the datasource? > >>> Thanks, > > >