Sending Emails through excel with a table attached in the body.

Hi All,

I would be really grateful if anyone could have a look at this please.

I have attached an example document.

What I am trying to do is email the table title and date to the emails in Col A and B.

If possible I would want Col A emails in the To and Col B emails in BCC, The email subject to be "Title Of Report"

I would want the first table to only go to the the emails in cells A2:A5 and B2

The Second table to only go to A11 and B11 and so on so fourth.

Please let me know if this is possible or if you think it can be done but the formatting might need changing for example each table needs a seperate tab.

the number of emails wont change niether will the size of the table.

Thanks