The best place to manipulate the data is in the database. There is no way
to do it as part of the mailmerge process.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"pschatz100" wrote in message
...
I use mail merge from a database to print mailing labels. I would like to
limit the number of characters that will be entered into a field so as not
to
mess up my label formatting. For example, I want no more than 20
characters
in the field for company name on my labels.

I am willing to simply truncate the data to the first 20 characters. No
fancy logic required. Thanks.