Macro for lotus to send individual mails to various receiptents

Hi senthikumar.k.chinn and welcome to the forum,

This is a strange request, using Lotus Notes. Because you are using Microsoft Excel I assume you also have Microsoft Word. There is a Mail Merge feature in Word that uses Excel Lists to do personalized form letters and send them out using the Word.

see http://office.microsoft.com/en-us/wo...001034920.aspx

I also found this article after feeling my above answer wasn't good enough.
http://sachachua.com/blog/2009/07/lo...l-spreadsheet/