255 limit on Mail Merge Fields?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SmogerP - 12 Nov 2004 17:00 GMT

Is there a 255 limit on Mail Merge Fields? I am merging data from MSAccess
97 to Word 97 utilizing a mail merge. I have set up a merge field. Run my
process, the data comes back, but the values are truncated at 255 characters.
Is there a way to allow for a large amount of characters for Mail Merge
Fields?

Thanks,

Reply to this Message

dixie - 14 Nov 2004 21:03 GMT

Are you sending the data out from within Access by using a query?

dixie

> Is there a 255 limit on Mail Merge Fields? I am merging data from
> MSAccess
[quoted text clipped - 6 lines]
>
> Thanks,

Reply to this Message

Cindy M -WordMVP- - 16 Nov 2004 17:40 GMT

Hi =?Utf-8?B?U21vZ2VyUA==?=,

> Is there a 255 limit on Mail Merge Fields? I am merging data from MSAccess
> 97 to Word 97 utilizing a mail merge. I have set up a merge field. Run my
> process, the data comes back, but the values are truncated at 255 characters.
> Is there a way to allow for a large amount of characters for Mail Merge
> Fields?

Yes, with reservations. Should work in Word 97 like this:

- Sort the merge data so that a record is at the top with more than 255
characters in the field in question

- In the Open Datasource dialog box, activate "Select method"

- Choose the MDB file

- In the dialog box that follows, select ODBC

- If you need to use a query, click "Options" and activate "Views"

- Select the table or query

The ODBC link should bring across > 255 characters, IF the first record in the
data source contains more than 255 characters in the memo field.

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

Reply to this Message