Memo field truncated in mailmerge

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

TIA
dixie

 

[Cindy M -WordMVP-]

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]

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

dixie

 

[Cindy M -WordMVP-]

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