Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2007

Tip: Looking for answers? Try searching our database.

Merge into a single record?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ulaluma - 28 Feb 2007 00:16 GMT
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 - 28 Feb 2007 04:35 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.