How to change the table value from Excel to outlook body

Hi Experts

I am stuck with something and I am not able to find the solution for it from last week. I tried many option and sirf net, but the end result is Zero.

I have created a Macro in VBA which send multiple mail for a go from excel to outlook. I somehow manage to get a code from Ron website to add a table in the body of the outlook. I am stuck with last option. I am looking for something like the value of the table should be changed for each mail.

I have attached the macro for your reference. I have added few sample data in the RAW_Data tab and Sheet2 tab is the table which is linked to the body of the outlook. The heading for both the sheet i.e. Sheet2 and RAW_DATA sheet is same. We can loop the code from either sheet. Is it possible to link the RAW_DATA in the body of each mail and the value of the table gets changed for every single mail.

Regards,
JD

AttachmentSize
Email macro.xlsm37.32 KB