Hi,

I'm trying to make a custom field in contact. The meaning is to combine salutation and last name and put geachte in front of it. Geachte is the same as dear in english. So I want to use the field for mail merge. 

The formula below does work, but there's one problem. Some people are called for example "van voorden" as their last name. If there's no first name before "van", then van must be a capital. What do I have to do to make "van" an capital automatically?

"Geachte" & " " & CASE(Salutation, "mevrouw", "mevrouw", "heer" ) & " " & LastName