[patchas]

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.

[Graham Mayor]

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.