MERGEFORMAT

[Meenu Hodiwalla]

I have a word database which stores names. It is desired
to have the last names in upper case in the database. But
when the last name field is printed in a mail merge
document, I would like it to be in title case. I went to
the online help, which talks about MERGEFORMAT to preserve
the format of a mail merge field during updates, but this
pertains to capitalization only. Since my data is already
in upper case, using this (for example, \* FirstCap), has
no effect.
I guess writing a macro would be one way out, but does
anyone know if word has a ready made solution for this ?
No point re-inventing the wheel.

Many thanks.

 

[Peter Jamieson]

I'd forget about the Mergeformat and, if you want to use firstcap, consider

{ QUOTE { MERGEFIELD myfield \*lower } \*Firstcap }