Option 1 - It could be done with macros, but it might get a bit tedious:
- Search for all entries where City begins with 'a'
- Create a continuous (looping) macro that deletes the first character of the City and replaces it with 'A'.
- Repeat the above for entries where City begins with 'b'.
- etc.
Obviously you don't have to do that for every letter of the alphabet. For instance, if you only have one or two entries that begin with 'U' it would be faster to edit them manually.
Option 2 - If you have Microsoft Access you can do the following:
- In the Windows ODBC Control Panel, create a System DSN for your Address Book that uses the Maximizer ODBC driver.
- Create a new Access database and link to the ADDRESS table.
- Create a new query, switch to SQL view and paste in the following
UPDATE ADDRESS SET ADDRESS.City = StrConv([City],3);
- Run that query.
Warnings:
1. It would be a really good idea to make a backup of your Address Book before performing a bulk update such as this.
2. Depending on the size of the database and the speed of your machine it might take a while.
