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 / April 2005

Tip: Looking for answers? Try searching our database.

excel/word merge: why are some data fields partially truncated?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
brooke - 01 Apr 2005 19:43 GMT
i am creating a word document based on an excel spreadsheet.  it appears that
some data fields (which are complete in excel) are truncated when they are
merged into the word document.  it seems to be a random occurance.  for
instance, it does not seem to be a factor of numbers of characters in the
data field.
Peter Jamieson - 02 Apr 2005 13:38 GMT
Unfortunately, I don't think anyone knows the answer to this question. There
are some suggestions that it is to do with either the total amount of data
in the record, or in the data source, or to do with a limit on some buffer
that Word uses during mailmerge - for example, it may try to cache a certain
number of records and start truncating fields when the buffer fills. One of
these days I may attempt some better controlled experiments to try to find
out, but I'd rather MS just made it work or told us what the limitations
are.

Peter Jamieson

>i am creating a word document based on an excel spreadsheet.  it appears
>that
> some data fields (which are complete in excel) are truncated when they are
> merged into the word document.  it seems to be a random occurance.  for
> instance, it does not seem to be a factor of numbers of characters in the
> data field.
 
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.