Excel data being cut off

[Guest]

I am trying to merge excel data into a word document. I have the merge set
up, and it works, but there is a comment section. The text in this section
can be a bit long, but does display in Excel. When the document is merged,
however, some of the text is lost. It looks like there is a predetermined max
of characters allowed in that field. I may except this, except for I have
another mail merge document doing the same type of thing, and it works
perfectly. Nothing is lost. Unfortunatly I don't know who origionally
created it, so I can't ask anyone.

 

[Doug Robbins - Word MVP]

From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. Then,
when you attach the data source to the mail merge main document, select the
DDE method of connection.

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