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 Merge Excel data into Word (both 2003)

Attach your data source to a Catalog (or in Word XP and later it is called
Directory) type mail merge main document in which you insert the mergefields
into the cells of a one row table with nothing else in the main document.
When you execute that merge to a new document, that document will contain a
table with a row of data for each record in the data source. If you want to
use this document as a data source, insert a row at the top of the table and
into the cells of that row, enter names for each field.

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

" wrote in message
...
Hello.

I have a lot of data created in Excel and would like to convert it into a
word data source and then convert it into a Publisher Directory. I do know
that I can merge the excel data into a directory but all of my fields are
not
showing up data is not showing up. This why I would like to try a reverse
way
of merging the data from Word
--
astro44