If statement using switches in Mergefields

[Naina Haria]

Dear All

Can anyone out there write an If statement for me please?
This is my problem. I have a merged word document in
Word97, the data that is merged to the document comes from
a database where the data is keyed in capital letters.
When it is merged to word, all the names and addresses are
in capitals. I have found using the Help file how to add a
switch that will convert the first letter of each word to
capitals but changes all the other letters to lowercase.
The switch is \*Caps. I now need to write an If statement
that will allow me to do the same with a name that has an
apostrophe in it. For example, Mrs O'Connor. If the
information is merged like MRS O'CONNOR, I want to be able
to add a switch that says if {mergefield
Custsurname\*caps} but if {mergefield O'CONNOR, then
make "O"\*caps and "C"*caps but only when there is an
apostrophe in the name. I have tried writing this code but
not had much luck.

Any one who can give me any assistance, it will be greatly
appreciated.

thanks

Naina

 

[Greg Maxey]

Naina,

I don't know if that is possible. A work around would be a find and
replace.

Edit>Replace>More>Use Wildcards

Type O'[a-z] in the find what field
Type ^& in the replace with field then press Format>Font and check all caps

Replace all.

 

[Gert Raes]

As I remember correctly there is also a switch "\* Lower"

So it should look like : {mergefield O'CONNOR \*Lower}
(but I'm not sure since I use Word2003