[Doug Robbins - Word MVP]

Using the default method of connection to the database, the type of data in
each field is deduced from the first eight or so records so if those records
do have sufficiently long comments associated with them, the data type may
be deduced to one with a limit of 255/256 characters.

You should be able to overcome the issue if in Word, you click on the Office
Button and then on Word Options and go to the Advanced tab and scroll down
to the General section of the dialog and check the box for "Confirm file
format conversion on open". Then when you attach your data source to the
mail merge main document, a Confirm Data Source dialog will open. Click on
the Show all box on this dialog and then select the MS Excel Worksheets via
DDE (*.xls) method of connection.

The alternative is to insert some dummy records at the top of the data
source that contain comments longer than 256 characters.

--
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, originally posted via msnews.microsoft.com

"JHeckman" wrote in message
...
[Win Vista, Office 2007 SP2]
I'm using a single Excel spreadsheet as a data source for a Word merged
document. My problematic field is 'comments.' While the merged doc DOES
show
multi-lines, it cuts off after about 250 characters of source data. Is
there
a field switch I can use to eliminiate this problem?