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. Has anyone any suggestions why
this may be happening?

TIA
dixie

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 :-)

It is Office 2000 and whatever is the default connection method is what is
in use.

dixie

"Cindy M -WordMVP-" wrote in message
news:VA.0000b0d6.005adbd3@speedy...
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 :-)

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 :-)