Quote:
Originally Posted by drecity
How do you export the address book to Excel?
|
In Outlook, you go to your contacts then under File select Import/Export then Export to a file then select Comma Seperated Values(Windows) Click Next on contacts then Next to save the file in your MyDocuments folder or browse to change the saving directory. This process creates a .csv file that can be opened in Excel then Imported back to Outlook using the same Import/Export option. I used this to transfer contacts from my phone to my wifes because she was missing a lot of our family and common contacts for some reason.
FYI... All this is assuming you synch your BB to Outlook or that you use Outlook in the first place...lol.
As for using this method to update all the 1s, this is a bit of a long way around. If you go into Contacts in Outlook and select the current view as Phone List you can easily click on each phone number the same as in Excel and add the 1.