I am trying to make a WORD Template for a standard set of file labels (Avery
5266). There are 4 pages of labels and the second lines are standard for
each group of labels; i.e., estimate, closeout, correspondence, etc.
However, I want to create template that allows the first line (job name) to
be entered once and repeated on each label. For example -
Reston Town Center
Estimate
Reston Town Center
Closeout
Reston Town Center
Correspondence
etc.
Any suggestions on how I do this. Thank you
Doug Robbins - 24 Sep 2004 00:10 GMT
You can use mailmerge to do it.

Signature
Please 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 am trying to make a WORD Template for a standard set of file labels
>(Avery
[quoted text clipped - 16 lines]
>
> Any suggestions on how I do this. Thank you
Graham Mayor - 27 Sep 2004 16:44 GMT
A standard label merge will place a NEXT field in each label but the first
which causes the merge to move to the next record.
If you want four labels each from the same record, then you have to remove a
few next fields. So if we are to assume that your database contains the job
names and you want four labels for each job then you would create something
along the lines of
Label 1 {Mergefield JobName}
{Mergefield Estimate}
Label 2 {Mergefield JobName}
{Mergefield Closeout}
Label 3 {Mergefield JobName}
{Mergefield Correspondence}
Label 4 {Mergefield JobName}
{Mergefield Other}{Next}
Label 5 {Mergefield JobName}
{Mergefield Estimate}
Label 6 {Mergefield JobName}
{Mergefield Closeout}
Label 7 {Mergefield JobName}
{Mergefield Correspondence}
Label 8 {Mergefield JobName}
{Mergefield Other}{Next}
Repeat this sequence until the page is filled.
If the second label line is to be plain text then a slightly different
approach is required
Label 1 {Mergefield JobName}
{IF{Mergefield JobName}<> "" "Estimate"}
Label 2 {Mergefield JobName}
{IF{Mergefield JobName}<> "" "Closeout"}
Label 3 {Mergefield JobName}
{IF{Mergefield JobName}<> "" "Correspondence"}
Label 4 {Mergefield JobName}
{IF{Mergefield JobName}<> "" "Other"}{Next}
Label 5 {Mergefield JobName}
{IF{Mergefield JobName}<> "" "Estimate"}
Label 6 {Mergefield JobName}
{IF{Mergefield JobName}<> "" "Closeout"}
Label 7 {Mergefield JobName}
{IF{Mergefield JobName}<> "" "Correspondence"}
Label 8 {Mergefield JobName}
{IF{Mergefield JobName}<> "" "Other"}{Next}
Repeat this sequence until the page is filled.

Signature
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> I am trying to make a WORD Template for a standard set of file labels
> (Avery 5266). There are 4 pages of labels and the second lines are
[quoted text clipped - 15 lines]
>
> Any suggestions on how I do this. Thank you