Mail merge several records on one page

[Pixie]

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

 

[Peter Jamieson]

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

 

[Lüko Willms]

Am Mon, 16 Oct 2006 19:51:01 UTC, schrieb Pixie

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.