lost text in merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cat Nichols - 02 Jul 2007 20:18 GMT

I'm losing text from the end of a field in my Word merge from my Excel file.
It seems to let me have about 48 or so words and then the rest is gone.

Reply to this Message

Peter Jamieson - 02 Jul 2007 21:06 GMT

1. Have a look at http://tips.pjmsn.me.uk/t0003.htm and for the moment you
probably need to use the "DDE" option. The limit is likely to be "255
characters" rather than a certain number of words.

Peter Jamieson

> I'm losing text from the end of a field in my Word merge from my Excel
> file.
> It seems to let me have about 48 or so words and then the rest is gone.

Reply to this Message

Cat Nichols - 03 Jul 2007 14:50 GMT

THANK YOU SO MUCH!!!!!!!!!!!!!!!!!!!
It worked and saved me much time and effort!!!!!!!!!!!!!!!

> 1. Have a look at http://tips.pjmsn.me.uk/t0003.htm and for the moment you
> probably need to use the "DDE" option. The limit is likely to be "255
[quoted text clipped - 5 lines]
> > file.
> > It seems to let me have about 48 or so words and then the rest is gone.

Reply to this Message

Doug Robbins - Word MVP - 02 Jul 2007 21:07 GMT

From information posted by a fellow contributor, Peter Jamieson, I
understand that Word looks at the first 8 or so records in the data source
to determine the type
of data in each field. If there is no field in any of those 8 or so records
that contains
more than 255 characters, that field in all subsequent records will be
truncated at 255 characters.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> I'm losing text from the end of a field in my Word merge from my Excel
> file.
> It seems to let me have about 48 or so words and then the rest is gone.

Reply to this Message