Merge into a single record?

[ulaluma]

I'm trying to use Word to mailmerge data from Excel columns. I'd like
each column to form a list in Word in a single page. So far I've only
gotten it to create multiple pages, one for each Record or Excel row.
Any suggestions?
Thanks,
Arianna

 

[Doug Robbins - Word MVP]

Use a catalog, or in Word XP and later it is called "directory" type
mailmerge main document in which you have a one row table into the cells of
which you insert the merge fields. When you execute that merge to a new
document, which is the only possible destination, the new document will
contain a table with a row of data for each record in the data source.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[ulaluma]

I thought that would work, it's what I have tried and just tried again
in a new document, but I get multiple pages: one page per row of data.
I don't understand what I'm doing wrong.
Thanks for your help,
Arianna

 

[ulaluma]

Never mind! Key words I missed: "Merge to a new document"!
Thanks!
Arianna