change case function

[Guest]

I thought there was a function that would let me case the case of a text
string to 'proper case' ...that would capitalize the first letter of each
word. I want to run a macro to change my contact names to this, right now
some have the last name all capitalized.
does anyone know how to do this?
thanks,
ck

 

[Michael Bauer [MVP - Outlook]]

UCase is the function you're looking for.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Quick-Cats - Categorize Outlook data:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>

Am Thu, 3 May 2007 06:11:00 -0700 schrieb Charlie:

 

[Michael Bednarek]

I thought there was a function that would let me case the case of a text
string to 'proper case' ...that would capitalize the first letter of each
word. I want to run a macro to change my contact names to this, right now
some have the last name all capitalized.
does anyone know how to do this?

Doesn't StrConv(strText,vbProperCase) do most of what you want? You'll
have to deal with special cases like "O'Brian", "McDonalds", "de la
Rossa", "von Braun" yourself.