On Thu, 3 May 2007 06:11:00 -0700, Charlie wrote in
microsoft.public.outlook.program_vba:

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.

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"