Updating Egyptian mobile numbers tool

Posted on October 3, 2011 by Mohamed Zaki

As NTRA (National Telecomm. Regulatory Authority) will change the mobile numbers ( increasing one digit and change the prefixes for the operators ) , most of us will face the problem of updating all his contacts on his mobile, with too many contacts, each might have more than one mobile this process will be dramatic.

I’ve worked on an Excel sheet automated with VBA script that and by pressing a single button and voila .. all your contacts will be updated to the new format.

Download it from here

The announced date for this modification is 6th-Oct-2011

Steps:

Export your contacts from your mobile or outlook if synched.
Paste your contacts in the Contacts sheet ( in any format not necessary using the existing one, it’s only an example).
Go to the Main Sheet and enter the columns that contain the numbers ( most of the current phones allow users to store different phones for a single contact ).

Enter the number of rows the script will go through ( if my numbers running down till row 300 then enter 300 in the Max Rows ).
Select the operator(s) you want to update its numbersPress “Update Numbers”.
Import the updated contacts to your phone or to outlook to be synched.

Note:

- You will need to allow macros.

How to export contacts from Outlook:

1- from File Menu –> Open –> Import (yes Import )

2- Select “Export to a file”

3- select “Microsoft Excel 97-2003”

4- Select contacts

5- choose folder to save the file in.

How to export IPhone contacts: http://www.trickyways.com/2010/06/how-to-export-iphone-contacts-as-csv-file-in-windows-7/
Download it from here

All your feedback is welcome

Rate this:

Like this:

One blogger likes this post.

Filed under: Uncategorized Tagged: | Egypt, Mobile Numbers Update, NTRA, NTRA mobile numbers

11 Responses

Shady Khorshed, on October 3, 2011 at 5:21 PM said:

Thanks ya Zaki for the amazing effort and idea

Reply
- Mohamed Zaki, on October 3, 2011 at 9:11 PM said:
  
  Thank you Shady, appreciating you kind support
  
  Reply
Fady, on October 3, 2011 at 7:29 PM said:

How to use it with iPhone?

Reply
- Mohamed Zaki, on October 3, 2011 at 9:09 PM said:
  
  This tool is not dependant on you mobile OS or type, if you have your contacts synched with outlook then export from outlook and continue the other steps mentioned in the post, otherwise you have to export the contacts from IPhone manually, update them using the tool then re-import.
  
  Reply
  - Fady, on October 3, 2011 at 9:38 PM said:
    
    I can export the contacts in vCard (.vcf) format by a special tool, how can I import the data into Excel and re-export it again?
    Thanks for help!
  - Mohamed Zaki, on October 4, 2011 at 7:44 AM said:
    
    please check this http://www.trickyways.com/2010/06/how-to-export-iphone-contacts-as-csv-file-in-windows-7/
    note: please keep the leading zeros in the mobile format ( I.e. 012 xxx xxxx and 002012 xxx xxxx )
BOB, on October 4, 2011 at 7:02 AM said:

the only comment i could say ” it’s mormal to get such a great solution from such a great Zaki ” good job ya man

Reply
Yasmine, on October 4, 2011 at 8:54 AM said:

Thanks ya Zika I will abandon all the tools and will use urs

Reply
Goodguy, on October 10, 2011 at 12:05 PM said:

If your contacts are already in Outlook there is Microsoft Outlook Add-In tool to update the new numbers directly which can then be synced with many GSMs:

http://blogs.msdn.com/b/egtechtalk/archive/2011/10/07/outlook-update-from-microsoft-egypt-to-modify-your-egyptian-mobile-numbers.aspx

If you have a GSM numbers in Excel files to be updated then this is a great tool… Thanks Zika!!

Reply
- Mohamed Zaki, on October 10, 2011 at 3:21 PM said:
  
  Wonderful Tool, viva developers
  
  Reply
Aziza, on October 26, 2011 at 4:44 AM said:

Good one. Was very helpful. Thank you so much

Reply

Mohamed Zaki's Blog

Twitter