Only part of data in Excel field is merged into Word Golfergirl 12/10/2008 1:45:00 PM I am using Office 2007. I successfully inserted merged fields from Excel into my form in Word. All but one of the fields came out fine. There was one field I called "notes" (from Excel) that would consist of several lines of information but when it is brought to Word, only the first few lines are shown in my document. In the document it displays exactly 2 1/2 lines of information, then nothing. It's like there is a limit on the inserted field size in Word. There is plenty of room left on the document to show the entire "notes" field. Please help!

Re: Only part of data in Excel field is merged into Word "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 12/10/2008 4:38:00 PM See http://tips.pjmsn.me.uk/t0003.htm The DDE method may be enough for you but it can be trouble in Office 2007. -- Peter Jamieson http://tips.pjmsn.me.uk "Golfergirl" <Golfergirl[ at ]discussions.microsoft.com> wrote in message news:9646E76E-61FC-4862-BD11-36C177EA47ED[ at ]microsoft.com... [Quoted Text] >I am using Office 2007. I successfully inserted merged fields from Excel >into > my form in Word. All but one of the fields came out fine. There was one > field > I called "notes" (from Excel) that would consist of several lines of > information but when it is brought to Word, only the first few lines are > shown in my document. In the document it displays exactly 2 1/2 lines of > information, then nothing. It's like there is a limit on the inserted > field > size in Word. There is plenty of room left on the document to show the > entire > "notes" field. Please help!

Re: Only part of data in Excel field is merged into Word "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 12/10/2008 7:46:05 PM From a friend, Peter Jamieson: Quote 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 Unquote -- 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 "Golfergirl" <Golfergirl[ at ]discussions.microsoft.com> wrote in message news:9646E76E-61FC-4862-BD11-36C177EA47ED[ at ]microsoft.com... [Quoted Text] >I am using Office 2007. I successfully inserted merged fields from Excel >into > my form in Word. All but one of the fields came out fine. There was one > field > I called "notes" (from Excel) that would consist of several lines of > information but when it is brought to Word, only the first few lines are > shown in my document. In the document it displays exactly 2 1/2 lines of > information, then nothing. It's like there is a limit on the inserted > field > size in Word. There is plenty of room left on the document to show the > entire > "notes" field. Please help!