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