If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
3 diff labels for each facility x 150 facilities
In MS Word 2003 I need to create 3 different labels for each facility (only
the last line is different in the label) and there are 150 facilities. I can create the three diff labels but the merge insists on moving to the next record for the second and third label even though I have removed the next record command. For example, I need Fac 1 Fac 1 Fac 1 FY2007 FY2007 FY2007 Teachers Students Staff and then repeat those three for the next facility and so on, for all 150 facilities. I am stumped. Any help please. |
#2
|
|||
|
|||
3 diff labels for each facility x 150 facilities
This will only work effectively if your label stock has labels in multiples
of three. Create a label merge source document (see http://www.gmayor.com/mail_merge_lab...th_word_xp.htm ) Propagate the labels then change the document type to Letters from the button on the mail merge toolbar (left end button). Now remove the {next} fields from the second label then the fourth and fifth, seventh and ninth etc to the end of the page. If your label blanks are not in multiples of three you will have to remove the next field from the extra label/s at the bottom of the page, which will give you four of five labels for one record per page. Change the last lines of the labels without a next record field as required. Merge to a new document and if you are worried about the waste, delete the contents from the extra labels, then use the method at http://www.gmayor.com/convert_labels...mail_merge.htm to create a new data file from the merged labels, then merge to a standard label merge using the resulting data file. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org patchas wrote: In MS Word 2003 I need to create 3 different labels for each facility (only the last line is different in the label) and there are 150 facilities. I can create the three diff labels but the merge insists on moving to the next record for the second and third label even though I have removed the next record command. For example, I need Fac 1 Fac 1 Fac 1 FY2007 FY2007 FY2007 Teachers Students Staff and then repeat those three for the next facility and so on, for all 150 facilities. I am stumped. Any help please. |
Thread Tools | |
Display Modes | |
|
|