repeating a job # on a standard set of file labels

[SueAnn]

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]

You can use mailmerge to do it.

--
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

 

[Graham Mayor]

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.


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>