Using code to split information in excel tabs into body of emai

Hello,

As my title suggests, I am looking to use information, I have split up into excel tabs, to go into the body of separate emails in outlook.

So what I have done so far is use a VBA code to split the data that I received into separate tabs.

Now i am looking to make a VBA code to make each tab go in the body of its own email (in outlook) and also to be emailed to the specific person in the relevant tab.


for example:

name Department bonus Manager email
Phil IT 100 JD Henderson jd@email.com

If this was an example of one tabs information. I would like to get the information into something like this:

to: jd@email.com

Dear JD Henderson,

Your employee Phil from IT is entitled to a bonus of 100 this year

regards

Barry Manilow



I hope this clarifies what I am looking for. So far I have only managed to make the code send it as an attachment.

kind regards

Michael