|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
February 11th 08, 04:05 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
how to change fullname to TitleCase
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 
|
| Ads |
|
#2
February 11th 08, 06:55 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
how to change fullname to TitleCase
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: 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
|
|
#3
February 11th 08, 08:26 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
how to change fullname to TitleCase
On Sun, 10 Feb 2008 20:05:01 -0800, Southern at Heart wrote in
microsoft.public.outlook.program_vba: 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. -- Michael Bednarek http://mbednarek.com/ "POST NO BILLS"
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook and OWA fullname field | Raffi[_2_] | Outlook - Using Contacts | 1 | September 11th 07 08:47 PM |
| how to change layout of contact list and to share after change | Vicki A | Outlook - Using Contacts | 1 | May 22nd 07 12:25 AM |
| Calendar should not change event times when time zones change. | Lawrence | Outlook - Calandaring | 0 | September 9th 06 07:29 PM |
| don't change meeting times in Mobile 2003 when timezones change. | fhorkey | Outlook - Calandaring | 1 | February 16th 06 03:44 PM |
| Why does Outlook 2003 Contact Form change with regional Unicode change | [email protected] | Outlook - General Queries | 0 | January 19th 06 03:50 AM |
Linear Mode
