Macro – send emails to lotus notes via excel

[sunilwadhwa]

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 : [email protected] & [email protected]

Sample file attached.

Hope someone can really help me with this.

[sunilwadhwa]

Can someone please help me with this one!!!

[sunilwadhwa]

Over a month and not a single response. Can someone please help!!!