|
| 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 24th 09, 07:08 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
How can I change the case of Outlook Contacts data?
I have imported data from an EXCEL file into my Outlook 2007 contacts. I now
have inconsisted upper and lower case use throughout the contacts. Some contacts are, for example, upper case: ROBERT SMITH and some are lower case: Mary Jones Can I tell Outlook, for example, to make all the entries in the column "initial upper case," so that ROBERT SMITH will become Robert Smith? I will appreciate advice. 
|
|
#2
February 25th 09, 12:01 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
How can I change the case of Outlook Contacts data?
You may wish to consider cleaning up the data at the source instead of
after the fact. Excel has several Text functions that would help in the process found under Formulas (for additional info - refer to Excel help file). Delete the original imported contacts and re-import the cleaned up file. Karl __________________________________________________ _ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2007" http://www.contactgenie.com "Robert Judge" wrote in message ... I have imported data from an EXCEL file into my Outlook 2007 contacts. I now have inconsisted upper and lower case use throughout the contacts. Some contacts are, for example, upper case: ROBERT SMITH and some are lower case: Mary Jones Can I tell Outlook, for example, to make all the entries in the column "initial upper case," so that ROBERT SMITH will become Robert Smith? I will appreciate advice.
|
|
#3
February 25th 09, 03:05 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
How can I change the case of Outlook Contacts data?
You'll need to do it in Excel before importing (using Excel's functions) as
outlook doesn't have the ability to change it, other than by your editing it. -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Outlook Tips by email: EMO - a weekly newsletter about Outlook and Exchange: You can access this newsgroup by visiting http://www.microsoft.com/office/comm...s/default.mspx or point your newsreader to msnews.microsoft.com. "Robert Judge" wrote in message ... I have imported data from an EXCEL file into my Outlook 2007 contacts. I now have inconsisted upper and lower case use throughout the contacts. Some contacts are, for example, upper case: ROBERT SMITH and some are lower case: Mary Jones Can I tell Outlook, for example, to make all the entries in the column "initial upper case," so that ROBERT SMITH will become Robert Smith? I will appreciate advice.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Change outlook data file path | Alex Verschoor | Outlook - Installation | 1 | April 21st 08 04:24 PM |
| How do I change data in a field across an array of contacts? | Max's Dad in Traverse | Outlook - Using Contacts | 1 | January 11th 08 07:45 PM |
| change case function | Charlie | Outlook and VBA | 2 | May 4th 07 07:18 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 |
Hybrid Mode
