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 / November 2006

Tip: Looking for answers? Try searching our database.

3 diff labels for each facility x 150 facilities

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
patchas - 05 Nov 2006 18:05 GMT
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 - 06 Nov 2006 06:16 GMT
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_labels_with_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_into_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.

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> 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
[quoted text clipped - 9 lines]
> 150 facilities.
> I am stumped.  Any help please.
 
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.