Automated email triggers with contents copied to 10 people once cell condition is met

[KK1234]

Hi everyone,
I have sheet1 which has many data in it.
The column12 is conditionally formatted to indicate the status. It is automatically populated with word 'overdue' when a condition is met.
It works fine.

I want now to have a VBA code to simply send email to specified group of 10 people automatically, with contents of that entire row ( column 1 to 12) attached or copied in email.
It sounds beyond me as I am very new in this field and learning.
The dummy sheet attached explains well. There are two questions in it. One on sheet1 and one on sheet2.
Sheet2 question pertains to transfer of data from one page to another which is another subject. I will deal with it in another post. If you want to help on that as well, then I will be thankful.

Can any one help please??