|
|
|
date: Thu, 3 Jul 2008 04:27:01 -0700,
group: microsoft.public.word.mailmerge.fields
back
Re: mail merge does not display full text
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.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Doug Robbins - Word MVP" wrote in message
news:O%237FjNU3IHA.4332@TK2MSFTNGP06.phx.gbl...
> 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.
>
> --
> Regards,
>
> Doug Robbins - Word MVP
>
> "Peter Jamieson" wrote in message
> news:%23ZpEKbQ3IHA.1436@TK2MSFTNGP05.phx.gbl...
>> 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.
>>
>> --
>> Peter Jamieson
>> http://tips.pjmsn.me.uk
>>
>> "Peter Jamieson" wrote in message
>> news:urzA3RQ3IHA.5112@TK2MSFTNGP03.phx.gbl...
>>> http://tips.pjmsn.me.uk/t0003.htm
>>>
>>> --
>>> Peter Jamieson
>>> http://tips.pjmsn.me.uk
>>>
>>> "Marlon" wrote in message
>>> news:21B54130-F9BE-49A1-8DC4-8E67B321CDD5@microsoft.com...
>>>>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.
>>>>
>>>>
>>>
>>
>
>
date: Thu, 3 Jul 2008 21:14:13 +0100
author: Peter Jamieson
|
|
