View Single Post
  #14266 (permalink)  
Old 03-23-2010, 06:52 PM
bsarlo's Avatar
bsarlo
PPCGeeks Regular
Offline
Location: Washington
 
Join Date: Feb 2010
Posts: 238
Reputation: 485
bsarlo is becoming a PPCGeeks regularbsarlo is becoming a PPCGeeks regularbsarlo is becoming a PPCGeeks regularbsarlo is becoming a PPCGeeks regularbsarlo is becoming a PPCGeeks regular
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Re: Remove +1 Dialing Prefix

Quote:
Originally Posted by powerplyer View Post
Bumping this one last time before I go back to MightROM. I really like this ROM but to change 400+ Contacts is a pain or I have spend $90.00 to find and replace all the +1 instances in Outlook.

Below is my issue, I think other have had similar issues.

Quote:
Originally Posted by powerplyer
Hello switched over from MightyRom to Cookie. This ROM is very stable and great. I have one issue that has been discussed in this forum is the +1 dialing. There is no solution yet, but I know it is fixable. My phone is synced to the corporate network and all the phone numbers have a +1 (xxx) xxx-xxxx format. In the Mighty Rom I was able to goto CDMA services and disable the prefix dialing. However in the Energy Cookie Rom this option is not available. I have tried Global and CDMA only and I do not see the options. Is there a CAB to enable these option or a reg hack to disable prefix dialing.

Thanks in advance for the help. I sure hope I there is a fix.
I'll do it for $20

**EDIT**

Just kidding. It can be done in about 15 min in 2010. Possible in 2007, but I can't remember how that works anymore it was so lond ago (Yawns arrogantly) LOL. Here we go:
1. Click File
2. Options
3. Advanced
4. Export
5. Export to a file - Next>
6. Microsoft Excel or Access (choose your weapon - I did Excel) - Next>
7. Select Contacts folder - Next>
8. Choose destination - Next>
9. Finish

Open file in Excel. Insert a column after the phone number column (lets call these A and B). Type this formula in cell B2 = if(A2="","",RIGHT(TRIM(A2),8 ) and copy that down to cell B401 (or the end of your contacts). Copy column B from B2 down and paste over column A from A2 down. Then in Outlook:

1. Click File
2. Options
3. Advanced
4. Export
5. Import from another program or file - Next>
6. Microsoft Excel - Next>
7. Replace Dups
8. Select Contacts folder - Next>
9. Finish

Yup.

Last edited by bsarlo; 03-23-2010 at 07:32 PM.
Reply With Quote