Word 2007

[Roxene]

I am trying to do a mail merge pulling data from Excel into fields in a Word
table. Excel fields with a larger amount of data are being cutoff during the
merge. The fix in 2003 was to use a DDE connection but when I attempt this
in 2007 i get an error that a DDE connection could not be established.

 

[Peter Jamieson]

I have also found DDE connections to Excel to be less reliable in 2007 (on
Vista, here).

As long as you have fewer than 64 columns in your sheet, I suspect your best
bet will be to select your data in Excel, Copy, then Paste it into a new
Word document, save that and use it as a data source.

Otherwise, do all the columns that contain cells with more than 255
characters of text have a cell with more than 255 characters in the first 8
rows? If not, can you experiment, i.e. copy your spreadsheet, modify the
data so that that is the case, and try reconnecting using OLE DB? (I cannot
be certain that this will work, and their are also other pitfalls when using
the default connection technique, as per http://tips.pjmsn.me.uk/t0003.htm.
But it seems worth trying).