How to Transfer an Excel Email Address to Lotus Notes

Updated April 17, 2017

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.

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

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

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.

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

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

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

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

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


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.

Things You'll Need

  • Excel 1995 or later
  • Lotus Notes 8.0 or later
bibliography-icon icon for annotation tool Cite this Article

About the Author

Ken Burnside has been writing freelance since 1990, contributing to publications as diverse as "Pyramid" and "Training & Simulations Journal." A Microsoft MVP in Excel, he holds a Bachelor of Arts in English from the University of Alaska. He won the Origins Award for Attack Vector: Tactical, a board game about space combat.