255 limit on Mail Merge Fields?

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,

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

dixie

"SmogerP" wrote in message
...
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,

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