Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    South Carolina, USA
    Thanked 0 Times in 0 Posts
    I have 3 columns (of about 20 rows) in an Excel 2007 worksheet (First Name, Last Name, E-mail) and I need to get them into Outlook contacts. Can this be done?

    Also, I want to click in Excel to open Outlook with that contacts name in the TO: field.

    I have the list of participants in Excel, if they do not attend the meeting, I want to send them email from the excel sheet.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts
    Make sure that the there is a row with column headers (First Name, Last Name and E-mail) above the data.
    Select the range with the column headers and the data and give it a name, for example Contacts.
    Save the workbook as an Excel 97-2003 workbook (.xls), not as an Excel 2007 workbook (.xlsx). Outlook 2007 stupidly does not support the new format.

    In Outlook, select File | Import and Export...
    Select Import from another program or file, then click Next.
    Select Microsoft Excel, then click Next.
    Click Browse, and select your Excel workbook, then click Next.
    Select Contacts as destination folder, then click Next.
    Click 'Map Custom Fields' to check whether Outlook will correctly interpret the columns, then click OK.
    Finally, click Finish.

    Excel should automatically turn the e-mail adresses into hyperlinks. Clicking such a hyperlink should start an e-mail to that address.

  3. The Following User Says Thank You to HansV For This Useful Post:

    cybermama (2012-02-06)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts