Expanding Excel > Lotus Notes mailing macro

Hi and good evening.

I'm Azlan and I'm received a project a few months ago involving Lotus Notes and Macros VBA, which both I'm not familiar with and started learning as I go.

I'm supposed to create a triggering system from Excel that sends Emails to recipients and am facing a bit of a problem.

I managed to make it read row by row, but I want it to loop the body of the email and send it to a single recipient.


This is the line of code that I have done so far.

Please Login or Register  to view this content.

These are my main questions:
1) can I make the body loop instead of manually adding row numbers?
2) Is there a way to change font colour using VBA?
3) Is there any way that I can sort everything into a table in Lotus Notes?

Attached is also the excel I'm working on.


I hope all you generous people can help me in my problem.

Thank you.