How do I change the case of text in contacts

K

KimW

Hello all,

I am new to this Forum so I hope you will be patient. I tried to search the
Forum for an answer to my question but was unsuccessful.

I am in the process of cleaning up an Outlook Contacts file which has names
entered in either all caps or all lower case.

Is there a way to change the case text in a group of records in Outlook
Contacts? I tried using Access -

I have linked Outlook Contacts to Access (both 2003) and I wrote an update
query:

UPDATE tblMyTableContacts SET [First] = StrConv([First],3);

It partially worked – when I view the data from Access the format is
correct. But when I look at the data from Outlook it is still unchanged.
After the query ran I had gotten an error message saying I did not have
permission - and it messed up the link to the table.

I am using Outlook and Business Contact Manager. I tried to update a single
record using Access by just re-typing the info. Like the query, it accepted
the changes when viewed in Access but not in Outlook.

Is there a setting in Outlook or Access that I need to change? Help please?

Thanks in advance,

Kim Walker
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word doc keeps changing to ALL CAPS 0
Office365 Outlook for work email change signature how ? 0
New computer, how do i move outlook 365 ENTIRELY? 0
How do I set focus (and select text) on a text box on a modeless userform? 0
How do I clear a form? 0
Change case of text in Outlook Contacts 4
Outlook 2010 Contacts 0
Outlook 2016 Add-in that creates an html signature doesn't embed images(logos). How can I do this ? 0

Top