Prepending "+1" to US phone numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Are you talking about new Contacts or your existing ones?
--
Russ Valentine
[MVP-Outlook]
liege168 said:
Forgive my ignorance in manipulating strings within Outlook 2003 as I'm a
Click to expand...
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.
 
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


Russ Valentine said:
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]
liege168 said:
I was referring to my existing ones. Thanks.
Click to expand...
Click to expand...
 
Back
Top