Maximum number of characters in a word merge field Tom Becker 6/27/2007 8:44:02 AM This is probabaly an easy one for you guys but its driving me crazy. I have a word merge supplied by excel, some of teh excel cells have quite a lot of information (upwards of 200 characters), some of the text contained therein merges where in other sections with the same length the text is cut off. WHY? When i tested it it all worked fine, now it does not I can't work out why. Anty help would be gratefully appreciated, ca't provide a copy of teh spreadsheet and word doc as its work sensitive. Tom

Re: Maximum number of characters in a word merge field "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 6/27/2007 8:50:29 AM From information posted by a fellow contributor, Peter Jamieson, I understand that Word looks at the first 8 or so records in the data source to determine the type of data. If there is no field in any of those 8 or so records that contains more than 255 characters, that field in all subsequent records will be truncated at 255 characters. -- 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 "Tom Becker" <Tom Becker[ at ]discussions.microsoft.com> wrote in message news:8506A375-8B09-4837-B091-99676C5B902F[ at ]microsoft.com... [Quoted Text] > This is probabaly an easy one for you guys but its driving me crazy. > > I have a word merge supplied by excel, some of teh excel cells have quite > a > lot of information (upwards of 200 characters), some of the text contained > therein merges where in other sections with the same length the text is > cut > off. WHY? > > When i tested it it all worked fine, now it does not I can't work out why. > > Anty help would be gratefully appreciated, ca't provide a copy of teh > spreadsheet and word doc as its work sensitive. > > Tom

Re: Maximum number of characters in a word merge field Tom Becker 6/27/2007 11:16:01 AM Doug, Thanks, but (and I may be being retarded here) I tried making the first merge field about 1,000 characters long (which I could then delete) but it still does not wok, even more oddly it did work for one field and not for another, however all formatting is the same. Tom "Doug Robbins - Word MVP" wrote: [Quoted Text] > From information posted by a fellow contributor, Peter Jamieson, I > understand that Word > looks at the first 8 or so records in the data source to determine the type > of data. If there is no field in any of those 8 or so records that contains > more than 255 characters, that field in all subsequent records will be > truncated at 255 characters. > > > -- > 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 > > "Tom Becker" <Tom Becker[ at ]discussions.microsoft.com> wrote in message > news:8506A375-8B09-4837-B091-99676C5B902F[ at ]microsoft.com... > > This is probabaly an easy one for you guys but its driving me crazy. > > > > I have a word merge supplied by excel, some of teh excel cells have quite > > a > > lot of information (upwards of 200 characters), some of the text contained > > therein merges where in other sections with the same length the text is > > cut > > off. WHY? > > > > When i tested it it all worked fine, now it does not I can't work out why. > > > > Anty help would be gratefully appreciated, ca't provide a copy of teh > > spreadsheet and word doc as its work sensitive. > > > > Tom > > >

Re: Maximum number of characters in a word merge field "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 6/27/2007 12:38:15 PM Just to clarify Doug's message, each column is treated separately. If column A has text <=255 characters in the first 8 rows (typically), column A will be treated as a "string" and any text in that column will be truncated to 255. If column B has even one text >255 in the first 8 rows the column should be treated as "memo". My on this issue are at http://tips.pjmsn.me.uk/t0003.htm but I don't claim that it is the complete picture, especially if you are using an older version of Word than (say) XP/2002, or your worksheet was created in an earlier version of Excel. Peter Jamieson "Tom Becker" <TomBecker[ at ]discussions.microsoft.com> wrote in message news:987EF771-9071-48AC-965B-6BA1EB96FD0B[ at ]microsoft.com... [Quoted Text] > Doug, > > Thanks, but (and I may be being retarded here) I tried making the first > merge field about 1,000 characters long (which I could then delete) but it > still does not wok, even more oddly it did work for one field and not for > another, however all formatting is the same. > > Tom > > "Doug Robbins - Word MVP" wrote: > >> From information posted by a fellow contributor, Peter Jamieson, I >> understand that Word >> looks at the first 8 or so records in the data source to determine the >> type >> of data. If there is no field in any of those 8 or so records that >> containsf >> more than 255 characters, that field in all subsequent records will be >> truncated at 255 characters. >> >> >> -- >> 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 >> >> "Tom Becker" <Tom Becker[ at ]discussions.microsoft.com> wrote in message >> news:8506A375-8B09-4837-B091-99676C5B902F[ at ]microsoft.com... >> > This is probabaly an easy one for you guys but its driving me crazy. >> > >> > I have a word merge supplied by excel, some of teh excel cells have >> > quite >> > a >> > lot of information (upwards of 200 characters), some of the text >> > contained >> > therein merges where in other sections with the same length the text is >> > cut >> > off. WHY? >> > >> > When i tested it it all worked fine, now it does not I can't work out >> > why. >> > >> > Anty help would be gratefully appreciated, ca't provide a copy of teh >> > spreadsheet and word doc as its work sensitive. >> > >> > Tom >> >> >>