Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge several records on one page
I am using Excel as a data source & want to put several records on one page
(eg Name, address etc) of up to 3 people per page in Word. I have tried the {NEXT} command, but with no success. Any ideas on how I can do this? Thanks |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge several records on one page
You don't say what you are doing with the { NEXT } comand, but this is
roughly how it is supposed to work: a. create the layout you want, with the fields you want. Let's assume it occupies about 1/3 of the page. Let's call that lot "copy 0" b. select the layout/text/fields and make two copies ("copy 1" and "copy 2") c. put a { NEXT } field before "copy 1" and a { NEXT } field before "copy 2". You do not need one before "copy 0". d. if you preview the merge you should see data from records 1,2 and 3. If you move to the next record, you should see records 2,3,4 , and so on. e. merge to the printer or an output document. However, in all probability you need "copy 0", "copy 1" and "copy 2" to occupy the same amount of space vertically, so it usually makes sense to create a 1-column, 3-row table and put the text+fields for each record in each cell. Ensur eyou insert the { NEXT } field using the facilities in the Word user interface, or using ctrl-F9 to insert the special field code braces {} then type NEXT between them. Have a look at what you're doing and see how it compares with that. Peter Jamieson "Pixie" wrote in message news I am using Excel as a data source & want to put several records on one page (eg Name, address etc) of up to 3 people per page in Word. I have tried the {NEXT} command, but with no success. Any ideas on how I can do this? Thanks |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge several records on one page
Am Mon, 16 Oct 2006 19:51:01 UTC, schrieb Pixie
auf microsoft.public.word.mailmerge.fields : I am using Excel as a data source & want to put several records on one page (eg Name, address etc) of up to 3 people per page in Word. Open MS-Word, call HELP, and search for "Catalog" (or how that would be spelled in your language, e.g. "Katalog" in German). There you find instructions on how to build a mailmerge document with repeating entries per page, without configuring more than one enty in the template. In VBA programming, you would assign ActiveDocument.Mailmerge.MainDocumentType = wdCatalog Yours, L.W. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge multi records on one page | Microsoft Word Help | |||
Mail merge and long tables | Mailmerge | |||
Mail Merge / Page break on record change | Mailmerge | |||
page number positioning and format | Page Layout | |||
Cannot edit Access records from Word mail merge toolbar button | Mailmerge |