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 / May 2004

Tip: Looking for answers? Try searching our database.

Descriptions coming from an Excel database are randomly cut

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
fcolli - 31 May 2004 10:36 GMT
I use mailmerge to produce a report made of pages with the same structure (Word2002) and containing fields with informations of a variable lenght (mostly comments and descriptions). The variable informations are stored into an external Excel2002 database
The amount of informations (the lenght of the string) contained in each field can be very variable, ranging from fields almost empty to others with even more than one thousand of characters

Problem
Randomly, and for no appearent reason, the fields in Word mailmerge result cut (for instance, in the middle of a word). The cut does not happen regularly at a certain length of the string.
The output, therefore, is not reliable to me, and it forces me - with a great effort - to double check the outputs and to correct the errors manually

Note that there seem not to be a problem with the field lenght, since I have complete forms with very long descriptions and others which are cut even having originally shorter descriptions

Thank you for your kind attention and for your help
Francesco Colli
Cindy M  -WordMVP- - 31 May 2004 16:52 GMT
Hi =?Utf-8?B?ZmNvbGxp?=,

We see this reported for merges from Excel using an OLE DB connection (the default for
Word 2002 and 2003).

Your best bet is to go back to one of the older connection technologies. You'll find
information on how to do this in the Word 2002 section of my website's mail merge FAQ.

> I use mailmerge to produce a report made of pages with the same structure (Word2002) and containing fields with informations of a variable lenght (mostly comments and
descriptions). The variable informations are stored into an external Excel2002 database.
> The amount of informations (the lenght of the string) contained in each field can be very variable, ranging from fields almost empty to others with even more than one thousand
of characters.
>  
> Problem:
> Randomly, and for no appearent reason, the fields in Word mailmerge result cut (for instance, in the middle of a word). The cut does not happen regularly at a certain length
of the string.
> The output, therefore, is not reliable to me, and it forces me - with a great effort - to double check the outputs and to correct the errors manually.

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 :-)

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.