How to move email addresses from verizon.netmail into droid contact list

Discussion in 'Android Tech Support' started by jensor4, May 13, 2013.

DroidForums.net is the premier Android Forum - Registered Users do not see these ads. Please Register - It's Free!
  1. jensor4
    Offline

    jensor4 New Member

    Joined:
    May 13, 2013
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Ratings:
    +0
    To move (export) contacts from verizon netmail to Android smart phone:
    Verizon doesn't have an export facility but here is a way around. First in Verizon netmail go to Contacts. Then select all contacts, then under Actions select Print Contacts.
    This will open two windows. Close the Print window, the second window has all the contacts listed.
    Now select all contacts in this window (ctl A), then Copy (ctl C), then paste these contacts into a new Excel sheet.
    Now you have to edit the formatting to get rid of excessive formatting etc. I copied the name column and the email address column onto a new sheet, then did a sort to eliminate the empty rows.
    You need to end up with 3 columns with the exact headings: Name, E-mail Address, and Phone.
    Now save this sheet as a csv file.
    If you don’t know how to do this, see detailed Excel edit instructions below.
    Now open your gmail account and go to contacts and under More, select import and then browse for and select the .csv file you saved.

    Detailed Excel edit instructions:
    Select column B (names) and copy. Then paste-special-values to column A in a new sheet.
    Select column E (addresses) and copy. Paste special-values to column B in the new sheet.
    Now in the new sheet widen columns A and B wide enough to see all the data.
    Notice that the addresses are displaced one row below the names. To correct this, select all addresses beginning with the first one and drag the selection up 1 row. Now move all the data (names and addresses) up so that first name and address begin on row 2.
    In cells A1, B1, C1 enter the column headings :Name, E-mail Address, and Phone. Now save the file as a .csv file.

    jensor4
    Last edited: May 26, 2013
  2. leeshor
    Offline

    leeshor DF Super Moderator Staff Member

    Joined:
    Jan 30, 2012
    Messages:
    3,083
    Likes Received:
    459
    Trophy Points:
    148
    Location:
    Norcross, GA - USA
    Ratings:
    +465
    Welcome to the forum

    Good job and a big help for anyone wondering how.
  3. jensor4
    Offline

    jensor4 New Member

    Joined:
    May 13, 2013
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Ratings:
    +0
    I searched high and low and could not find out how to do this. So I fooled around and discovered this work around.
    Since no one seems to know how to do this even Verizon themselves that posting probably deserves to be made a sticky.
    jensor4
  4. jensor4
    Offline

    jensor4 New Member

    Joined:
    May 13, 2013
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Ratings:
    +0
    A sort is needed to eliminate the empty rows

    Add the highlighted sentence to the procedure:

Search tags for this page

export verizon email contacts

,
export verizon mail contacts to android
,

export verizon.net email contacts

,
exporting email contacts from verizon
,

how to export contacts from verizon email

,

how to export email contacts from verizon

,

how to get email addresses out of contacts on droid verizon

,
import contacts from verizon.net to android
,

verizon email export contacts

,
verizon mail move contacts list