Mail Merge from Excel to Word truncates at 255 Chars.

[whatsinaname]

We are using Office XP, and one of our users is merging an Excel spreadsheet into Word. Several of the Excel columns contain over 255 characters. When we merge the document, Word truncates one of the fields at 255 characters. Is there a limit to the number of characters in a field that can be merged, or do we need to change something in Word? Thanks.

 

[SkipVought]

whatsinaname,

You stated...

merging an Excel spreadsheet into Word

Are you merging a SPREADSHEET or are you merging DATA from a spreadsheet?

I did a Mail Merge with text data from my workbook in excess of 255 bytes.

I am running Office 2003 in WIN XP. How about you?

How are you merging?

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[whatsinaname]

They were merging text data from the spreadsheet using Office XP. I was not able to recreate the problem using a new merge document, but the original document always truncated. To rule out Excel, I imported the Excel spreadsheet into Access and merged that, with the same results. I finally got the merge to stop truncating by changing the layout to landscape from portrait. There was no truncation when in landscape. I then changed the merge document back to portrait, and ran the merge once again. It now merged all of the data without any truncation. This is weird, because I took that entire document apart piece by piece and performed the merge at each step, and it still would truncate. It's working now, but I'm going to keep looking for the cause. Thanks for responding.