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

[Tgs at work]

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]

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