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 | Display Modes |
#1
|
|||
|
|||
automated find and replace of area codes in outlook
I want to search throughh all my Outlook address entries for an area code of
"0171" and change them all to "+44 207". I have several hundred numbers to change and have lost interest while I'm still in the "A's"! Thanks. |
#2
|
|||
|
|||
Look for third party utilities he
http://www.slipstick.com/addins/contacts.htm -- Russ Valentine [MVP-Outlook] "DAZ" wrote in message ... I want to search throughh all my Outlook address entries for an area code of "0171" and change them all to "+44 207". I have several hundred numbers to change and have lost interest while I'm still in the "A's"! Thanks. |
#3
|
|||
|
|||
I've done this in the past by exporting my contacts to a database or excel file, doing a find/replace, and then importing the contacts back into a new contacts folder. One problem you may run into relates to the Notes field. If you have a lot of data in there, it doesn't always survive the export/import - I'm not sure what the length limit is. Also, any numbers that start with "0" need to be double-checked if using excel to be sure the leading zero wasn't deleted. -- Gurs ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message1058073.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find and Replace with Wildcards | Luke Muehlhauser | General Discussion | 2 | August 8th, 2004 02:55 AM |
Find and Replace in Word 97 | Doug Robbins - Word MVP | General Discussion | 1 | May 28th, 2004 02:41 PM |
Find and Replace Merge Codes | SandyE | Mailmerge | 0 | May 15th, 2004 09:53 PM |
find all / replace all used in a selected range | oldguy | Worksheet Functions | 0 | February 26th, 2004 01:05 PM |
find all / replace all used in a selected range | Tom Turtle | Worksheet Functions | 0 | February 26th, 2004 10:11 AM |