Macro – send emails to lotus notes via excel

Hi,

Can someone please help me with a macro for selecting a range in excel and sending an email using lotus notes.

Column “J” has the email address of the sales rep. The macro should filter on each sales rep and copy/paste data on a new email and send it to the respective email address.

Subject line should read: Siebel Opportunity Past Due
Mail body: “Given below is a list of opportunities that are past due. Please update Siebel accordingly.”

If there is no email address mentioned on column “J”, then that range should go to two specific email addresses : abc@abc.com & cab@cab.com

Sample file attached.

Hope someone can really help me with this.