View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default How can I merge Excel file data into word document?

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
wrote in message
...
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.