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
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.

Signature
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
> 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
ulaluma - 01 Mar 2007 17:47 GMT
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 - 01 Mar 2007 17:58 GMT
Never mind! Key words I missed: "Merge to a new document"!
Thanks!
Arianna