255 limit on Mail Merge Fields?

[SmogerP]

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,

 

[dixie]

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

dixie

 

[Cindy M -WordMVP-]

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