Data missing from merged document

[Marseldav]

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?

 

[Doug Robbins - Word MVP]

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.

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

 

[Marseldav]

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

 

[Doug Robbins - Word MVP]

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

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

 

[Marseldav]

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

 

[Doug Robbins - Word MVP]

Bit tedious to enter into a spreadsheet, but having done so, the merge
creates a bulleted list with all of those schools listed.

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

 

[Doug Robbins - Word MVP]

De-spam my email address and send me your data source if you like and I will
see if I can find the problem.

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

 

[Marseldav]

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