Group:  Microsoft Word ยป microsoft.public.word.mailmerge.fields
Thread: Data missing from merged document

Geek News

Data missing from merged document
Marseldav 5/29/2007 5:56:01 PM
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?
Re: Data missing from merged document
"Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 5/29/2007 8:58:16 PM
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" <Marseldav[ at ]discussions.microsoft.com> wrote in message
news:34E11600-1681-4BCE-BB18-FF747DCD41DD[ at ]microsoft.com...
[Quoted Text]
> 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?


Re: Data missing from merged document
Marseldav 5/30/2007 12:37:01 PM
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" wrote:

[Quoted Text]
> 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" <Marseldav[ at ]discussions.microsoft.com> wrote in message
> news:34E11600-1681-4BCE-BB18-FF747DCD41DD[ at ]microsoft.com...
> > 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?
>
>
>
Re: Data missing from merged document
"Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 5/30/2007 1:39:13 PM
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" <Marseldav[ at ]discussions.microsoft.com> wrote in message
news:D4CCF294-038F-414A-B8E4-B2C3C26A037C[ at ]microsoft.com...
[Quoted Text]
> 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" wrote:
>
>> 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" <Marseldav[ at ]discussions.microsoft.com> wrote in message
>> news:34E11600-1681-4BCE-BB18-FF747DCD41DD[ at ]microsoft.com...
>> > 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?
>>
>>
>>


Re: Data missing from merged document
Marseldav 5/30/2007 2:36:04 PM
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" wrote:

[Quoted Text]
> 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" <Marseldav[ at ]discussions.microsoft.com> wrote in message
> news:D4CCF294-038F-414A-B8E4-B2C3C26A037C[ at ]microsoft.com...
> > 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" wrote:
> >
> >> 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" <Marseldav[ at ]discussions.microsoft.com> wrote in message
> >> news:34E11600-1681-4BCE-BB18-FF747DCD41DD[ at ]microsoft.com...
> >> > 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?
> >>
> >>
> >>
>
>
>
Re: Data missing from merged document
"Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 5/30/2007 3:54:25 PM
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

"Marseldav" <Marseldav[ at ]discussions.microsoft.com> wrote in message
news:C14794EF-234C-4FF1-AB77-0BBBFEB3B8D3[ at ]microsoft.com...
[Quoted Text]
> 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" wrote:
>
>> 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" <Marseldav[ at ]discussions.microsoft.com> wrote in message
>> news:D4CCF294-038F-414A-B8E4-B2C3C26A037C[ at ]microsoft.com...
>> > 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" wrote:
>> >
>> >> 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" <Marseldav[ at ]discussions.microsoft.com> wrote in message
>> >> news:34E11600-1681-4BCE-BB18-FF747DCD41DD[ at ]microsoft.com...
>> >> > 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?
>> >>
>> >>
>> >>
>>
>>
>>


Re: Data missing from merged document
"Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 5/30/2007 3:55:01 PM
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" <Marseldav[ at ]discussions.microsoft.com> wrote in message
news:C14794EF-234C-4FF1-AB77-0BBBFEB3B8D3[ at ]microsoft.com...
[Quoted Text]
> 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" wrote:
>
>> 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" <Marseldav[ at ]discussions.microsoft.com> wrote in message
>> news:D4CCF294-038F-414A-B8E4-B2C3C26A037C[ at ]microsoft.com...
>> > 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" wrote:
>> >
>> >> 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" <Marseldav[ at ]discussions.microsoft.com> wrote in message
>> >> news:34E11600-1681-4BCE-BB18-FF747DCD41DD[ at ]microsoft.com...
>> >> > 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?
>> >>
>> >>
>> >>
>>
>>
>>


Re: Data missing from merged document
Marseldav 5/30/2007 7:06:01 PM
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

"Doug Robbins - Word MVP" wrote:

[Quoted Text]
> 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
>
> "Marseldav" <Marseldav[ at ]discussions.microsoft.com> wrote in message
> news:C14794EF-234C-4FF1-AB77-0BBBFEB3B8D3[ at ]microsoft.com...
> > 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" wrote:
> >
> >> 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" <Marseldav[ at ]discussions.microsoft.com> wrote in message
> >> news:D4CCF294-038F-414A-B8E4-B2C3C26A037C[ at ]microsoft.com...
> >> > 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" wrote:
> >> >
> >> >> 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" <Marseldav[ at ]discussions.microsoft.com> wrote in message
> >> >> news:34E11600-1681-4BCE-BB18-FF747DCD41DD[ at ]microsoft.com...
> >> >> > 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?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net