Thread: [Solved] Mail Merge truncating 'some' of the text fields......Not sure what to do
View Single Post
 
Old 09-26-2010, 07:57 AM
sssb2000 sssb2000 is offline Windows XP Office 2007
Novice
  
Join Date: Sep 2010
Posts: 6
sssb2000 is on a distinguished road
Default
Quote:
Originally Posted by Kimberly View Post
Word looks at the data in the first record in the datasource in order to decide what you need. I suspect that some of your fields are merging OK because they have more than 256 characters in the first record. Edit the first record so that it has more than 256 characters in any fields that are long for some records.


To do the DDE thing, follow these steps:
In Word 2007...Office Button >
Word Options > Advanced > General > Confirm file format conversion on open
Then close Word and re-open, reconnect to the Excel file and then you will be given the option of connecting via DDE

If you have Window XP, you do not need a service pack for Windows 2000. The problem you are having is a common complaint about mail merge and does not indicate anything about what service packs you have.
Thank you for your reply.
Could you please explain what you mean by the blue text above? (what's a first record?)
Also, i verified and i have word 2002. sorry.
but i did get to your steps and the problem is that once i try to open the excel, word forces itself to close.
Reply With Quote