Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Need a nice looking list Need a nice looking list is offline
external usenet poster
 
Posts: 1
Default How can I merge Excel file data into word document?

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



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I attach data from an Excel file to a Word document? mia New Users 1 October 10th 06 11:43 PM
merge data from 2 excel worksheets into one word document S.Kulshekar Mailmerge 2 August 1st 06 10:33 AM
Mail Merge from data in excel to word document. Karrie Mailmerge 1 November 9th 05 03:47 PM
Merge data in Excel Spreadsheet into a word document Prospect Hospice Mailmerge 1 April 22nd 05 08:31 PM
mail merge using excel file as data source Laurina Mailmerge 1 January 31st 05 03:10 PM


All times are GMT +1. The time now is 10:36 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"