String Length Limit on Mail Merge from Excel ??

[Chris]

Hi

I am trying to mail merge with excel however some of the
cell contents (text strings) that are being merged into
the word doc are quite long (300+ characters). Only so
much of the text from that cell is merged. Is there a
limit to the string length and if so can it be
increased / bypassed ?

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Chris,

This is the response from fellow MVP Cindy Meister to the post from Jean
Pereira with the subject "Merge Word XP and Excel XP" dated 10/01/2004.

Quote

Hi Jean,

Recently upgraded from Office 2000 to Office XP and had a
merge set up with regular field codes to bring in info
from Excel.

In XP only the first 255 chars in any cell is merged. How
do you increase the character limit?

Is this the same merge document, or a newly-created merge?
In Office 2000, when you opened such a saved mail merge
document did it also open Excel? (I'm trying to determine
which connection method was used.)
FWIW, I tested this the other day for someone, with 300
characters in a cell. And it worked fine in Word 2002. I note,
however, that the Excel file was NOT created in an earlier
version of Excel...
And does the same happen when you open this kind of mail
merge document in Word 2002?
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail

Unquote

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

 

[Chris]

Hi Doug

Thanks for the reply. I am using an excel 2000 file so
this seems to be the problem. Thanks again for the
prompt response, its appreciated.

Chris