Sending eMail using Excel data through lotus Notes

[Amdivns]

Hello,

I am trying to automate a document request process by creating a spreadsheet which is then used by to automatically send individual eMails using cells as the subject and body text. Below is an example of what i'm trying to do. Also, the destination eMail will always stay the same. A macro button to start the mail process would also be handy!

Subject - Request for original documents - (A2:A99) - (B2:B99)

Hello,

Please action the below request at your earliest convenience

Member Name: (A2:A99)
Member #: (B2:B99)
Case#: (C2:C99)
Location: D2:D99)
Folder: (E2:E99)
Document ID: (F2:F99)
Requested by: (G2:G99)
Date Requested: (E2:E99)

Regards,

Amdivns


Here is an example spreadsheet I am using. I have trawled the web- but can't find a decent code


A B C D E F G H
[TABLE="width: 1017"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Member #[/TD]
[TD]Case #[/TD]
[TD]Location[/TD]
[TD]Folder[/TD]
[TD]Document ID[/TD]
[TD]Requested By[/TD]
[TD]Date Requested[/TD]
[/TR]
[TR]
[TD]TEST TEST[/TD]
[TD]113721433[/TD]
[TD]12345678[/TD]
[TD]123456789[/TD]
[TD]AA[/TD]
[TD]I12345678[/TD]
[TD]JOHN DOE[/TD]
[TD]14/11/2014[/TD]
[/TR]
</tbody>[/TABLE]


Any help would be most appreciated!!