Prepending "+1" to US phone numbers

[liege168]

Forgive my ignorance in manipulating strings within Outlook 2003 as I'm a novice at this. I have over 1k entries, with most of the entries for the US, following the (xxx) xxx-xxxx format. I'd like to prepend the phone number entries with "+1" if the numbers do not already have "+YY" for other countries already. Could someone provide me with detailed instructions on how to accomplish this? Many thanks.

 

[Russ Valentine [MVP-Outlook]]

Are you talking about new Contacts or your existing ones?
--
Russ Valentine
[MVP-Outlook]

Forgive my ignorance in manipulating strings within Outlook 2003 as I'm a

novice at this. I have over 1k entries, with most of the entries for the
US, following the (xxx) xxx-xxxx format. I'd like to prepend the phone
number entries with "+1" if the numbers do not already have "+YY" for other
countries already. Could someone provide me with detailed instructions on
how to accomplish this? Many thanks.

 

[liege168]

I was referring to my existing ones. Thanks.

 

[Russ Valentine [MVP-Outlook]]

Outlook has no search and replace function.
Most users export to Excel, do the search and replace there, and then
re-import.
Other methods are described here:
http://www.slipstick.com/outlook/searchreplacecompany.htm

 

[awesterink]

I've used the Excel method before. Works fine. Too bad Outllok doe not let
you apply the formatting you want to the entire list of contacts, but oh
well.
- from File, chose Import and Export->Export to File->contacts.csv
- open the csv file in Excel
- replace all "(" by "+1 (", assuming all your contacts are in NA, save file
- import the csv file into you contacts folder, overwriting duplicates

Outlook has no search and replace function.
Most users export to Excel, do the search and replace there, and then
re-import.
Other methods are described here:
http://www.slipstick.com/outlook/searchreplacecompany.htm

--
Russ Valentine
[MVP-Outlook]

I was referring to my existing ones. Thanks.