Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge does not display full text
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge does not display full text
http://tips.pjmsn.me.uk/t0003.htm
-- Peter Jamieson http://tips.pjmsn.me.uk "Marlon" wrote in message ... 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. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge does not display full text
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 ... http://tips.pjmsn.me.uk/t0003.htm -- Peter Jamieson http://tips.pjmsn.me.uk "Marlon" wrote in message ... 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. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge does not display full text
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 ... 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 ... http://tips.pjmsn.me.uk/t0003.htm -- Peter Jamieson http://tips.pjmsn.me.uk "Marlon" wrote in message ... 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. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 ... 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 ... 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 ... http://tips.pjmsn.me.uk/t0003.htm -- Peter Jamieson http://tips.pjmsn.me.uk "Marlon" wrote in message ... 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. |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge does not display full text
I did just as you suggested and it worked! Thank you very much!
Marlon "Peter Jamieson" wrote: 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 ... http://tips.pjmsn.me.uk/t0003.htm -- Peter Jamieson http://tips.pjmsn.me.uk "Marlon" wrote in message ... 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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge - text wont display correctly | Mailmerge | |||
How do I get mail merge to print full zip codes | Mailmerge | |||
How do I get mail merge to print full zip codes | Mailmerge | |||
How do I get mail merge to print full zip codes | Mailmerge | |||
Printing a full page of labels using Mail Merge fields | Microsoft Word Help |