Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / January 2004

Tip: Looking for answers? Try searching our database.

String Length Limit on Mail Merge from Excel ??

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chris - 10 Jan 2004 17:40 GMT
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 CHARACTERS FROM EMAIL ADDRESS - 10 Jan 2004 22:53 GMT
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
> Hi
>
[quoted text clipped - 4 lines]
> limit to the string length and if so can it be
> increased / bypassed ?
Chris - 12 Jan 2004 17:56 GMT
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

>-----Original Message-----
>Hi Chris,
[quoted text clipped - 47 lines]
>
>.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.