PDA

View Full Version : create e-mailing with excel and lotus notes



kws
02-28-2011, 11:45 AM
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,

JP2112
03-01-2011, 12:45 PM
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/even-more-awesome-lotusscript-mail-merge-for-lotus-notes-microsoft-excel/

shrivallabha
03-01-2011, 11:05 PM
Here's one more:
http://www.vbaexpress.com/forum/showthread.php?t=35917&highlight=lotus