Hi Dixie,
> I have a mailmerge with a memo field that seems to be truncated at about 255
> characters when it merges. I actually think the Access query that sends the
> merge data to it is truncating the field.
Which version of Office is this (including SP! - look in the Help/About if you
don't know)?
Do you know which data connection method you're using to link the mail merge to
Access?
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)
Dixie - 28 Jun 2005 01:21 GMT
It is Office 2000 and whatever is the default connection method is what is
in use.
dixie
> Hi Dixie,
>
[quoted text clipped - 20 lines]
> reply
> in the newsgroup and not by e-mail :-)
Cindy M -WordMVP- - 28 Jun 2005 11:36 GMT
Hi Dixie,
> It is Office 2000 and whatever is the default connection method is what is
> in use.
No SP? Then that explains the problem. Office 2000, original release, had a
top character number of 255 for text coming through mail merge. SP-1 or SP-2
(can't remember which) changed that (at least for an ODBC connection) to
32,000+ characters.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)