mail merge does not display full text

[Marlon]

I have a word document which I mailmerged with an excel database containing
long (text) sentences. Most of the merge fields display the contents of the
excel database properly, but some merge fields does not show the text in
full.

Any ideas?

Thank you.

 

[Peter Jamieson]

http://tips.pjmsn.me.uk/t0003.htm

 

[Peter Jamieson]

Sory, I meant to indicate the specific problem rather than just quote an
article. The problem is likely that in the column with the problem, if the
first 8 rows have texts shorter than 255 characters, the OLE DB provider
that Word uses to get the data from Excel will truncate any longer texts in
the rest of the column. If you can set even one of those 8 values to be
longer than 255 characters you should see the full texts.

 

[Doug Robbins - Word MVP]

Hi Peter,

I wonder why they don't use the setting IMEX=1 in the default connection
string so that the checking of the data type for the first 8 records does
not dictate what is brought across. I don't know too much about the
Registry, but I wonder if there is a setting there that can be modified to
achieve that.

 

[Peter Jamieson]

Hi Doug.

They do use IMEX = 1 - it's probably the best choice available given how the
provider works, but there are still quite a lot of problems that it doesn't
fix. I've had a pretty good look at the documented registry entries and
connection string options and cannot see a way to improve things except the
ones I've documented in my web page. Of course I may have failed to spot an
opportunity, and there could be undocumented options as well but I haven't
dug that deep.

AFAICS the way Word would really prefer to work would be to have everything
come over as text (or memos), even if it couldn't be formatted as displayed
in Excel (i.e. the way DDE does it, more or less). As things stand, that
only happens if the column is a text/memo column or there's a mix in the
first TypeGuessRows.

 

[Marlon]

I did just as you suggested and it worked! Thank you very much!

Marlon