mail merge excel to word text Emily 8/1/2006 12:29:02 AM It seems there is a maximum allowable text length when merging from Excel to Word. One of my merge fields is a text description that can range anywhere from a couple sentences to an entire paragraph. It seems to cut off after a certain number of characters. Is there any way I can fix this? I know you can choose an unlimited text length when using the form textboxes, is there a way to do the same in a mail merge?

Re: mail merge excel to word text "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 8/1/2006 3:25:18 AM From the Tools menu in Word, select Options and then go to the General tab and check the box against "Confirm conversions at open" Then when you attach the data source, choose the DDE option in the dialog box that asks you for the method by which the connection to the data source should be made. I think that this will overcome the 255 character limit that you are up against at the moment. -- 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 "Emily" <pickles_1977[ at ]yahoo.com> wrote in message news:5C96E60F-C1FB-4765-B2D7-21A5CF3430BB[ at ]microsoft.com... [Quoted Text] > It seems there is a maximum allowable text length when merging from Excel > to > Word. One of my merge fields is a text description that can range > anywhere > from a couple sentences to an entire paragraph. It seems to cut off after > a > certain number of characters. Is there any way I can fix this? I know > you > can choose an unlimited text length when using the form textboxes, is > there a > way to do the same in a mail merge?

Re: mail merge excel to word text Karen 12/4/2008 11:25:14 AM Didn't work for me I'm afraid. Changed the option, closed Word then tried again but it still only gave me 255 chars. I've got around it by splitting the long comment in two but this is a not the ideal solution. "Doug Robbins - Word MVP" wrote: [Quoted Text] > From the Tools menu in Word, select Options and then go to the General tab > and check the box against "Confirm conversions at open" Then when you > attach the data source, choose the DDE option in the dialog box that asks > you for the method by which the connection to the data source should be > made. I think that this will overcome the 255 character limit that you are > up against at the moment. > > -- > 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 > > "Emily" <pickles_1977[ at ]yahoo.com> wrote in message > news:5C96E60F-C1FB-4765-B2D7-21A5CF3430BB[ at ]microsoft.com... > > It seems there is a maximum allowable text length when merging from Excel > > to > > Word. One of my merge fields is a text description that can range > > anywhere > > from a couple sentences to an entire paragraph. It seems to cut off after > > a > > certain number of characters. Is there any way I can fix this? I know > > you > > can choose an unlimited text length when using the form textboxes, is > > there a > > way to do the same in a mail merge? > > >

Re: mail merge excel to word text "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 12/4/2008 4:22:29 PM If possible, try ensuring that one of the first 8 cells in the column in question has more than 255 characters in it (e.g. you may be able to create a dummy record like that at the beginning of the sheet and then exclude it from the merge). (See http://tips.pjmsn.me.uk/t0003.htm for a lengthy explanation) -- Peter Jamieson http://tips.pjmsn.me.uk "Karen" <Karen[ at ]discussions.microsoft.com> wrote in message news:F39B3823-3F49-4EAA-A6CB-1092C814C7EC[ at ]microsoft.com... [Quoted Text] > Didn't work for me I'm afraid. Changed the option, closed Word then tried > again but it still only gave me 255 chars. I've got around it by splitting > the long comment in two but this is a not the ideal solution. > > "Doug Robbins - Word MVP" wrote: > >> From the Tools menu in Word, select Options and then go to the General >> tab >> and check the box against "Confirm conversions at open" Then when you >> attach the data source, choose the DDE option in the dialog box that asks >> you for the method by which the connection to the data source should be >> made. I think that this will overcome the 255 character limit that you >> are >> up against at the moment. >> >> -- >> 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 >> >> "Emily" <pickles_1977[ at ]yahoo.com> wrote in message >> news:5C96E60F-C1FB-4765-B2D7-21A5CF3430BB[ at ]microsoft.com... >> > It seems there is a maximum allowable text length when merging from >> > Excel >> > to >> > Word. One of my merge fields is a text description that can range >> > anywhere >> > from a couple sentences to an entire paragraph. It seems to cut off >> > after >> > a >> > certain number of characters. Is there any way I can fix this? I >> > know >> > you >> > can choose an unlimited text length when using the form textboxes, is >> > there a >> > way to do the same in a mail merge? >> >> >>