How to Transfer an Excel Email Address to Lotus Notes

Written by ken burnside Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Transfer an Excel Email Address to Lotus Notes
Moving a list of e-mail addresses from Excel to Lotus Notes is easy. (e-mail image by Soja Andrzej from Fotolia.com)

Excel will convert an e-mail address into a click-able link. Sometimes, it's necessary to copy that e-mail address into Lotus Notes (or another e-mail program) to add it to your contacts.

Skill level:
Easy

Other People Are Reading

Things you need

  • Excel 1995 or later
  • Lotus Notes 8.0 or later

Show MoreHide

Instructions

  1. 1

    Open Excel. Select the email address you want to transfer.

  2. 2

    Press "Ctrl-C" to copy the email address.

  3. 3

    Open Lotus Notes. Click on the menu item for "File" and select "New Contact." In the dialogue window that opens up, select the field labelled "email address" and press "Ctrl-V" to paste the email address in.

  1. 1

    Open the Excel workbook with the list of e-mail addresses you want to import.

  2. 2

    Click on the "Office" button in Excel, and select "Save As" from the menu item.

  3. 3

    Choose Comma Separated Values (*.csv) from the file format drop down on the menu that appears. Click the button that says "Save."

  4. 4

    Open Lotus Notes. Click on the "File" menu item, and select "Import."

  5. 5

    Select "Browse" from the menu. In the dialogue box that appears, select the CSV file you created earlier. Select "Open" from the dialogue box.

Tips and warnings

  • Lotus Notes will merge imported contacts with your existing contacts, rather than overwrite them.
  • In earlier versions of Lotus Notes, you may need to save the Excel data as a WKS (Lotus 1-2-3 Worksheet) file.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.