create e-mailing with excel and lotus notes

Hey,

I' am trying to create an e-mailing to several different people from excel. This to send them their pasword and username. Is it possible to create a macro that automatically generate e-mails when i have opened my lotus notes. In the excel file i have 3 different collums; one with the e-mail adresses, one with the password and one with the username. if i can added text so i become an standard e-mail like: this is your ....
Thkns for the help,

Sounds like a job for mail merge, I would do a search for "lotus notes mail merge" and see what comes up. This one looks promising:

http://sachachua.com/blog/2010/05/ev...crosoft-excel/

Here's one more:
http://www.vbaexpress.com/forum/show...ighlight=lotus