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 / June 2007

Tip: Looking for answers? Try searching our database.

How do you merge a document with several records on one page?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tgs at work - 06 Jun 2007 20:46 GMT
Using Microsoft Office Word 2003 and Excel 2003, I am trying to create labels
in Word with only one field, but several records from Excel.  When I merge, I
am only given the option to have one record per page.  Which won't work with
several labels on each page.  I have done this previously, but don't remember
how, but know it can be done.  I beleive I used a "next record" command, but
can't find it anywhere as a possibility.  
Please help!
Peter Jamieson - 07 Jun 2007 10:25 GMT
Typiclaly in Word when you use the Mail Merge Wizard, you would select a
label merge, then define a layout (which consists of  Word table with one
cell per label (although sometimes there are "spacer" cells that should not
contain anything). Then you define the text and fields to go in the first
cell, then you use the Propagate function to copy that content to each other
cell, with a { NEXT } (i.e. <<Next record>>) field at the beginning of each
label cell . Then you need to "complete the merge", i.e. actually print the
labels of output to a new document.

You can also enable the MailMerge toolbar to help you do all that.

If you need to use the data from multiple rows in each label, you can insert
additional { NEXT } fields. If you have enabled the MailMerge toolbar, you
can use the Insert Word Field button to do that, or you can position the
insertion point where you need the field and use ctrl-F9 to insert the
special "field code braces" {}, then type NEXT in between.

However, that will only work if you have exactly the same number of Excel
rows for every label. If the number can vary, you will probably be better
off modifying your data source before trying to produce the labels.

Peter Jamieson

> Using Microsoft Office Word 2003 and Excel 2003, I am trying to create
> labels
[quoted text clipped - 8 lines]
> can't find it anywhere as a possibility.
> Please help!
 
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.