B

brinkmad

Visitor

 • 

1 Message

My Cox phone "address book" on VoiceTools

VoiceTools (logging in on my desktop PC) has an "Address Book" in the top right corner. To be more accurate, it should be called a "phone book." Regardless, it ties in with Call History. I use it to add clarity to my Call History, such as adding a name when only a number appears, or tying a work phone and a cell phone to one person. I use this to identify and track business call activity. 

My "address book" data could be useful to me for another project. Would there be a way for me to export it as .csv or .xlsx?

Discussions

 • 

Updated 

107

1

0

C

CurtB

+4 more

Honored Contributor

 • 

2.1K Messages

Voice Tools doesn't provide an Address Book contacts export function.  Copying data into Excel and formatting it isn't as easy as an export, but it's not hard.  Option 1: Copy contacts one letter at a time A to Z.  This allows more than the nine contacts maximum that can be copied from the multi-line grid (and is easier to manage).  Option 2:  Mark every contact as a favorite, then click the "Favorites" link on the top row.  This displays a single-spaced list of all contacts flagged as favorites.  That would now be ALL your contacts.  You can then select all contacts at once to copy and "Paste Special" into the Excel worksheet at cell "B2". 

  • Open a blank Excel worksheet.
  • Open "Address Book" in Voice Tools.
  • Option1: Copy Address Book contacts to clipboard one letter at a time, A to Z.  Tab to the Excel spreadsheet , right click and "Paste Special" into the next available row in column "B'" starting with "B2".  Repeat copy and Paste Special until all contacts A to Z have been pasted into the worksheet.
  • Option 2: Mark all contacts as a favorite and click the "Favorites" link at the top.  Select the displayed contacts, pulling the cursor down to scroll to the bottom, copying all entries in the list.  Tab to the Excel spreadsheet, right click and "Paste Special" into "B2".

When all contacts have been copied into column "B":

  • Copy the following formula to "C2" for contact name.

=IF(LEFT($B3,4)<>"Name","",PROPER(RIGHT($B3,LEN($B3)-5)))

  • Copy the following formula to "D2" for phone number (references next row in data).

=IF(LEFT($B4,14)<>"Phone Number: ","",IF(RIGHT($B4,6)="Office",MID($B4,16, LEN($B4)- 21),MID($B4,16,LEN($B4)-19)))

  • Copy the following formula to "E2" for phone type (office, cell, home).

=IF(RIGHT($B4,6)="Office",RIGHT($B4,6),IF(RIGHT($B4,4)="Cell",RIGHT($B4,4),IF(RIGHT($B4,4)="Home",RIGHT($B4,4),"")))

  • Copy formulas in "C2:E2" down to all rows thru the last row containing copied data (nnn).
  • Copy "C2:Ennn" and Paste Special into "F2" to convert cell contents from formulas to text.
  • Save the Excel workbook (to retain copied data in case you missed a step).
  • You can delete copied data in column "B" and delete or hide columns "C:E"  (formulas).
  • Sort "F2:Hnnn" to collapse contact data.  Move to where you want the final results.

Note: If a contact has more than one phone number, it will have a small down arrow to the right of the type in the webpage list.  Multiple phone numbers are only visible using webpage functionality to display the additional numbers and are therefore not available for copying.  Those additional numbers would have to be processed manually. 

(edited)

1

0

C
CurtB

+4 more

Honored Contributor

 • 

2.1K Messages

Just to do it... I wrote a macro and assigned it to a button to handle the Excel copy and paste stuff.  Now I click the Address Book "Favorites" link, copy all contacts, tab over to Contacts workbook, click the "Format Data" button and done.  Contact names, phone numbers and types are listed alphabetically with no other cell content displayed.  The macro runs in about 0.05 second (about 1/20th of a second).  It's pretty quick, but I don't really use Address Book much and haven't created many contacts.

Like

Reply

0