Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do you merge a document with several records on one page?
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! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do you merge a document with several records on one page?
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 "Tgs at work" Tgs at wrote in message news 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! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging several records into one merge document results in page breaks. | Mailmerge | |||
Mail merge several records on one page | Mailmerge | |||
Merge Multiple Records per page | Mailmerge | |||
merge related records onto a page w/new page at defined data | Mailmerge | |||
Merge all records to same page in word97 | Mailmerge |