How can I merge Excel file data into word document?

  • Thread starter Need a nice looking list
  • Start date
N

Need a nice looking list

I am trying to merge Excel data into Word document, but am only able to get
one set of fields per page. I am trying to make a list. Mail Merge doesn't
seem to allow me to have each of the entries, only one at a time, or one per
page.
 
D

Doug Robbins - Word MVP

Use a Catalog, or in Word XP and later it is called Directory, type mail
merge main document in which you set up one set of the fields that you want
in the configuration that you want them. Do not insert any <<Next Record>>
fields as they are not necessary. When you execute the merge to a new
document, which is the only possible destination, that new document will
have one set of the data in the way in which you arranged it, 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

"Need a nice looking list" <Need a nice looking
(e-mail address removed)> wrote in message
news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top