|
| 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
May 3rd 07, 03:11 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
change case function
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 
|
|
#2
May 4th 07, 07:13 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
change case function
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
|
|
#3
May 4th 07, 07:18 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
change case function
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"
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Email Addresses Case Sensitive? | CWLee | Outlook Express | 6 | May 20th 06 01:20 AM |
| Changin case of alphabet in Contacts | Tim | Outlook - Using Contacts | 1 | May 8th 06 03:55 PM |
| Outlook PST case | tonrado | Outlook - General Queries | 5 | February 22nd 06 05:28 PM |
| How to sychronize in this case: | Josie Walsh | Outlook - General Queries | 2 | February 4th 06 09:22 PM |
| How to sychronize in this case: | Josie Walsh | Outlook - Using Contacts | 2 | February 4th 06 09:22 PM |
Hybrid Mode
