changing cases for whole mail merge series

[mel.noble]

I have created a data merge using the catalogue form but when i merge
the records from file maker, some are in uppercase, lower case or just
the wrong case because that is how they have been entered in the
database. does anyone know how to format the fields so that everything
will be consistent for each record please?

 

[Peter Jamieson]

The best you can do within Word is to use one of the "text formatting
switches", e.g. where you have a field code such as

{ MERGEFIELD myfield }

type \*FirstCap to give you

{ MERGEFIELD myfield \*Lower }

to make all the text lower case.

There are four capitalisation switches - \*Caps, \*FirstCap, \*Upper and
\*Lower. They are all there in Word Help. However, \*FirstCap /just/ does
capitalisation - it doesn't make the rest of the text lower case. So if you
want consistency, you might need something more like

{ QUOTE { MERGEFIELD myfield \*Lower } \*FirstCap }

where all the {} are the special "field braces you can insert in pairs using
command-F9.

Peter Jamieson
You can use the {a} button in the Preview section of the Data Merge Manager
to reveal the underlying field codes.