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
|
|||
|
|||
Prepending "+1" to US phone numbers
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.
|
#2
|
|||
|
|||
Prepending "+1" to US phone numbers
Are you talking about new Contacts or your existing ones?
-- Russ Valentine [MVP-Outlook] "liege168" wrote in message ... 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. |
#3
|
|||
|
|||
Prepending "+1" to US phone numbers
I was referring to my existing ones. Thanks.
|
#4
|
|||
|
|||
Prepending "+1" to US phone numbers
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 he http://www.slipstick.com/outlook/sea...acecompany.htm -- Russ Valentine [MVP-Outlook] "liege168" wrote in message ... I was referring to my existing ones. Thanks. |
#5
|
|||
|
|||
Prepending "+1" to US phone numbers
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 [MVP-Outlook]" wrote in message ... 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 he http://www.slipstick.com/outlook/sea...acecompany.htm -- Russ Valentine [MVP-Outlook] "liege168" wrote in message ... I was referring to my existing ones. Thanks. |
Thread Tools | |
Display Modes | |
|
|