 |
 | 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 / May 2007Data missing from merged document
I've used Excel as my datasoure to create a merged document in word. However, data is missing from my merged document. Is there a set limit for the data that can be displayed in each field? Why is data missing from my merged document? Please give examples of the data that is contained in the field, both that that is being merged and that which is missing. It seems that Word considers the first 10 or so records to determine the type of data and then may fail to handle subsequent records for which the data in the field does not match the sample.  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 > I've used Excel as my datasoure to create a merged document in word. > However, [quoted text clipped - 3 lines] > Why > is data missing from my merged document? The data in this particular cell is all text. I entered the data using Alt+Entr to display separate items. I work in education so my information entered is col1 with header 'schoolboards' , col2 with header 'schools' so subsequent rows list the board in col1 and col2 listing all the schools relating this board appearing in one cell. In my merged document the schools will be displayed bulletted. The problems occurs where there are more than 9 schools listed for a board. HELP!!!! > Please give examples of the data that is contained in the field, both that > that is being merged and that which is missing. It seems that Word [quoted text clipped - 9 lines] > > Why > > is data missing from my merged document? I cannot replicate that problem with a datasource that I created where I had 20 items in the cells of a spreadsheet with each item separated by Alt+Enter as you mention 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 > The data in this particular cell is all text. I entered the data using > Alt+Entr to display separate items. I work in education so my information [quoted text clipped - 23 lines] >> > Why >> > is data missing from my merged document? Can you use the following as your test data. This is akin to what I've put in my excel spreadsheet (all in one cell). Reni Grudon Elementary School McKel Public School Tom Lingboet Jr. Public School Riden Public School Purkdele Public School Hallcrest Community School Chister Elementery School Rusethorn Junior School egnes MecPheil Public School Keele Mountview Public School GY Little School Williem G. Duvis Junior Public School Whatney Public School The Elmo Junior Middle School Kensington Community School Wist Glan Junior School Western Technicel end Commericel School West Hill Gollegiet Institute Don Mills Collegiete Institute Dr. Normen Bethune Collegiete Institute > I cannot replicate that problem with a datasource that I created where I had > 20 items in the cells of a spreadsheet with each item separated by Alt+Enter [quoted text clipped - 27 lines] > >> > Why > >> > is data missing from my merged document? Bit tedious to enter into a spreadsheet, but having done so, the merge creates a bulleted list with all of those schools listed. 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 > Can you use the following as your test data. > [quoted text clipped - 57 lines] >> >> > Why >> >> > is data missing from my merged document? Thanks Doug. This probably means that it is something in the global settings of my documents/applications that is giving me this limitation. Thanks again > Bit tedious to enter into a spreadsheet, but having done so, the merge > creates a bulleted list with all of those schools listed. [quoted text clipped - 60 lines] > >> >> > Why > >> >> > is data missing from my merged document? De-spam my email address and send me your data source if you like and I will see if I can find the problem. 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 > Can you use the following as your test data. > [quoted text clipped - 57 lines] >> >> > Why >> >> > is data missing from my merged document?
|
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.