• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Is there an Outlook tool to normalize text for entries that are in ALL CAPS?

Norm

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
#1
Is there an Outlook tool to normalize text for entries that are in ALL CAPS? I have tons of entries that are in all caps and would like to, at the very least, have all proper names have only the first letter capitalized.
 
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
#2
No tool that i am aware of... what type of entries are they? If contacts, a macro could handle it easy enough.

I have a bunch of 'bulk change contacts' macros - none do exactly this, but making it do proper case shouldn't be a problem.

Bulk Change Email Display Name Format
 
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
#3
this is what you'll use to convert it to proper case.
Code:
          With objContact
    
.FullName = StrConv(.FullName, vbProperCase)

             .Save
          End With
 

Similar threads