Substitute bookmarks/subject from Outlook message from Excel rows/cells then loop

[nylevolm]

Hi Excel experts!

I need your expertise with this please.

The data is in excel.

In the Outlook message, (zip file attachment) those in blue font, need to be substituted by data from the excel spreadsheet. I've done this with MS Word, but I can't seem to mirror the same output with Outlook. Help please!

The subject also has to come from the excel data.

If it's also possible to get the email addresses based on the first name and last name in the cell, that would be very helpful!

I tried some codes to experiment, but all have failed. So you can just ignore the modules I created.

Thanks in advance!