HELP: Recode macro for sending email via lotus notes

[sunilwadhwa]

Hi,

I’ve a macro for sending emails via lotus notes using excel. However, I need help on re-coding the macro a little bit. Column J has a list of email addresses it needs to go to. When I run the macro it sends a screenshot of the entire worksheet to just one person. Need help with –

1. Macro should copy/paste data relevant only to the person listed on column J and send an email out. When there is a change in email address only that data needs to be sent to that respective person via lotus notes.
2. The body of the email is at the bottom of the mail. Can it be changed so that the body is on top and the screenshot below that.
3. If column J has “Update Lead Partner” then those should be sent to a particular email. For testing purpose we can use: [email protected] & [email protected]

I’m okay even if it can be sent as an excel attachment if it’s not possible to send screenshot.

Sample spreadsheet attached. Hope someone can help me out with this.

Regards,
SW
Siebel Past Due Decision Date Q3 Wk7 2012 (V2).xls

[sunilwadhwa]

Hope someone can help me with this request. Urgent request