Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / September 2004

Tip: Looking for answers? Try searching our database.

repeating a job # on a standard set of file labels

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SueAnn - 23 Sep 2004 18:55 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.