how to change fullname to TitleCase

[Southern at Heart]

I need to change the fullname to Proper case or Title case.
I can't get the syntax for this second line...

My code
....
For Each Contact In objAllContacts
Contact.FullName.case = vbProperCase
Contact.Save
Next
....

Am I close?
Southern@Heart

 

[Michael Bauer [MVP - Outlook]]

Do you want to have the first character in upper and the rest in lower
cases? Use the mid function to access specific characters. Then use the
UCase and LCase functions to convert them.

--
Best regards
Michael Bauer - MVP Outlook
Use Outlook Categories? This is Your Tool:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>

Am Sun, 10 Feb 2008 20:05:01 -0800 schrieb Southern at Heart:

 

[Michael Bednarek]

I need to change the fullname to Proper case or Title case.
I can't get the syntax for this second line...

My code
...
For Each Contact In objAllContacts
Contact.FullName.case = vbProperCase
Contact.Save
Next
...

Am I close?

Have a look at the documentation for the function StrConv; e.g.
Contact.FullName = StrConv(Contact.FullName, vbProperCase)
might work.