 |
mail merge does not display full text
|
|
On Thu, 3 Jul 2008 04:27:01 -0700, Marlon <...@discussions.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.
|
How to create a template letter
[03 Sep 2008]
On Wed, 3 Sep 2008 06:25:02 -0700, bsharp <bsharp@discussio ns.microsoft.com
I am using...
Word and Outlook 2007.
How do I create a template letter that I can re-use the next time...
|
How do I format a mail merge/directory book?
[02 Sep 2008]
On Tue, 2 Sep 2008 07:46:01 -0700, mikepcc <mikepcc@discussi ons.microsoft.com
I'm trying...
to create a booklet of membership info for a club. I want to
format it for printing. ...
|
Mail merge recipients - edit button?
[02 Sep 2008]
On Tue, 2 Sep 2008 22:28:00 -0700, Steve Geard <SteveGeard@discu ssions.microsoft.com
...
When I click on "Mail Merge Recipients" in Word 2003, to display a list of my
mail merge ...
|
| More... |
|
|
|
|
On Thu, 3 Jul 2008 13:17:36 +0100, "Peter Jamieson" <...@KillmapSpjjnet.demon.co.uk
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" <...@TK2MSFTNGP03.phx.gbl...
|
|
On Fri, 4 Jul 2008 05:31:23 +1000, "Doug Robbins - Word MVP" <...@REMOVECAPSmvps.org
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" <...@TK2MSFTNGP05.phx.gbl...
|
|
On Thu, 3 Jul 2008 21:14:13 +0100, "Peter Jamieson" <...@KillmapSpjjnet.demon.co.uk
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" <...@TK2MSFTNGP06.phx.gbl...
|
|
On Fri, 4 Jul 2008 03:20:01 -0700, Marlon <...@discussions.microsoft.com
I did just as you suggested and it worked! Thank you very much!
Marlon
>
|
|
|