1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Importing e-mail addresses from excel

Discussion in 'Windows Vista' started by RS69, Oct 1, 2008.

Thread Status:
Not open for further replies.
  1. RS69

    RS69 Thread Starter

    Joined:
    Oct 1, 2008
    Messages:
    6
    I have a list of e-mail addresses in an excel file, some of which are already on my hotmail contacts. Is there a way I can update my contacts list directly from excel?
     
  2. TheOutcaste

    TheOutcaste

    Joined:
    Aug 7, 2007
    Messages:
    9,028
    Welcome to TSG!

    You can import contacts into Windows Live Mail/Hotmail from a CSV (Comma Separated Value file) in Outlook format or Outlook Express format. You just need to export the contacts as a CSV, with the data in the right locations:
    For Outlook line must contain 92 columns (cells). The first line is the header which tells what data is in each cell. The following is the first row of the spreadsheet.
    Code:
    Title,First Name,Middle Name,Last Name,Suffix,Company,Department,Job Title,Business Street,Business Street 2,Business Street 3,Business City,Business State,Business Postal Code,Business Country,Home Street,Home Street 2,Home Street 3,Home City,Home State,Home Postal Code,Home Country,Other Street,Other Street 2,Other Street 3,Other City,Other State,Other Postal Code,Other Country,Assistant's Phone,Business Fax,Business Phone,Business Phone 2,Callback,Car Phone,Company Main Phone,Home Fax,Home Phone,Home Phone 2,ISDN,Mobile Phone,Other Fax,Other Phone,Pager,Primary Phone,Radio Phone,TTY/TDD Phone,Telex,Account,Anniversary,Assistant's Name,Billing Information,Birthday,Business Address PO Box,Categories,Children,Directory Server,E-mail Address,E-mail Type,E-mail Display Name,E-mail 2 Address,E-mail 2 Type,E-mail 2 Display Name,E-mail 3 Address,E-mail 3 Type,E-mail 3 Display Name,Gender,Government ID Number,Hobby,Home Address PO Box,Initials,Internet Free Busy,Keywords,Language,Location,Manager's Name,Mileage,Notes,Office Location,Organizational ID Number,Other Address PO Box,Priority,Private,Profession,Referred By,Sensitivity,Spouse,User 1,User 2,User 3,User 4,Web Page
    Outlook Express is a bit easier as you only need 29 columns:
    Code:
    First Name,Last Name,Middle Name,Name,Nickname,E-mail Address,Home Street,Home City,Home Postal Code,Home State,Home Country/Region,Home Phone,Home Fax,Mobile Phone,Personal Web Page,Business Street,Business City,Business Postal Code,Business State,Business Country/Region,Business Web Page,Business Phone,Business Fax,Pager,Company,Job Title,Department,Office Location,Notes
    In Hotmail, click on Options on the right, then More Options, then scroll down to Import Contacts, Under Option 2 check the file type (Outlook or Outlook Express) then browse to the file, then click Import Contacts.

    You could also export your Windows Live Mail contacts, which will save a CSV on your PC, then open that in Excel to see the format, then import choosing Windows Live Mail as the source.

    HTH

    Jerry
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/755269

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice