Sending Outlook Emails from/using Excel VBA - Outlook and Excel

Dear Excel VBA experts,

I have a problem and hopefully you could help me out here. I have also attached an excel file for scenarios, as well as my desired outcome.

What I wanted on the final outcome is to have emails that I have created in Excel, to be sent out to the respective addresses (to, cc and/or bcc), along with the message and the signature.

In the attached example, there should be a total of 3 emails to be sent out (assuming that "to", "cc" and "bcc" are included as 1 email, as the content of the body is the same).

For example, in scenario 1, there should be 3 email addresses in the "to" and "cc" fields and 1 email address in the "bcc" field. With the message of the header (Excel Cell Range A1 to D1) in Excel as well as how it is shown in Excel of Cell Range A2 to D2, and finally the signature.

In scenario 2, 1 email address in the "to", "cc" and "bcc" field with header (Excel Cell Range A1 to D1) as well as Excel Cell Range A3 to D7, and the signature at the bottom.

In scenario 3, only 1 address in the "to" field, with header (Excel Cell Range A1 to D1) and Excel Cell Range A8 to D9, and the signature at the bottom.

So basically, column F is the "criteria" to check how many "lines" of data to input on the body before it decides to create a new email to send.

I hope that with my attachment and a little of explanation here, you understand completely what I desire to achieve.

Your help is deeply appreciated in making my work life easier!!!