 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / April 2008Merge Excel data into Word (both 2003)
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  Signatureastro44 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. SignatureHope 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 > Hello. > [quoted text clipped - 5 lines] > way > of merging the data from Word Doug, After I have merged the data from Excel into the table in Word, there is a total of 6 entries in the actual table and I have a least 2000+ Please advise Signatureastro44 > 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 [quoted text clipped - 13 lines] > > way > > of merging the data from Word How did you set up the mail merge main document? With a one row table, or a six row table? It sounds like you might have done the latter and are just previewing the results rather than actually executing the merge. SignatureHope 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 > Doug, > [quoted text clipped - 29 lines] >> > way >> > of merging the data from Word Doug, I setup one row as you instructed. But what I meant to say was, when looking at the Catalog record I only have 6 entries, and it appears that there are other entries in the Catalog record but it's only a check box and not the data itself. Thanks Signatureastro44 > How did you set up the mail merge main document? With a one row table, or a > six row table? It sounds like you might have done the latter and are just [quoted text clipped - 33 lines] > >> > way > >> > of merging the data from Word Have you actually executed the merge to a new document? SignatureHope 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 > Doug, > [quoted text clipped - 53 lines] >> >> > way >> >> > of merging the data from Word
|
Reply to this Message |
 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.