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:

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