Change case of text in Outlook Contacts

[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. 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

 

[John Nurick]

Hi Kim,

I'd do this by running code in Outlook, along the lines of this
pseudocode

For Each C in ContactsFolder.Items
C.FirstName = StrConv(C.FirstName, 3)
Next

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. 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

 

[KimW]

Thanks John! I have not run code in Outlook before.Would you do this with SQL
Server? If not, how? Sorry to be so dumb here.

Kim

Hi Kim,

I'd do this by running code in Outlook, along the lines of this
pseudocode

For Each C in ContactsFolder.Items
C.FirstName = StrConv(C.FirstName, 3)
Next

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. 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

 

[John Nurick]

SQL Server doesn't come into it, Kim. Outlook can run VBA code in the
same way as Access and the other Office applications. Check out
http://www.outlookcode.com/ and http://msdn.microsoft.com for
information.

Thanks John! I have not run code in Outlook before.Would you do this with SQL
Server? If not, how? Sorry to be so dumb here.

Kim

Hi Kim,

I'd do this by running code in Outlook, along the lines of this
pseudocode

For Each C in ContactsFolder.Items
C.FirstName = StrConv(C.FirstName, 3)
Next

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. 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

 

[KimW]

Yeah - I saw that I can use VBA in Outlook directly after I made that post.

You would think there would be an easy fix - surely I am not the only person
wanting to change the case of text. There was an article I found on
Microsoft.com but the code it had was a select query and not an uopdate
query. I found another example on this forum of the upodate query that I ran,
but then the error message. Sheesh. Ok - I will stop ranting now.

Thanks again John.

Kim

SQL Server doesn't come into it, Kim. Outlook can run VBA code in the
same way as Access and the other Office applications. Check out
http://www.outlookcode.com/ and http://msdn.microsoft.com for
information.

Thanks John! I have not run code in Outlook before.Would you do this with SQL
Server? If not, how? Sorry to be so dumb here.

Kim

Hi Kim,

I'd do this by running code in Outlook, along the lines of this
pseudocode

For Each C in ContactsFolder.Items
C.FirstName = StrConv(C.FirstName, 3)
Next

On Tue, 30 Nov 2004 16:13:02 -0800, "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. 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