Email rows if conditions met

I'm working in a vehicle workshop and I am trying to build a program that will email each service advisor via outlook, their outstanding jobs which have all parts available.
(parts are ordered and the customer might take the car away, I want the advisors to be reminded daily so that they can get the customers back in for the parts to be fitted).

My current sheet takes all of its information from our WIP handling system and is updated every morning automatically.

Basically I am trying to set it so that IF date in column E is < TODAY AND Column D = All parts available AND column F = OUT THEN email the advisor in Column C all and only the rows that apply to that advisor.
Then email the management team a summary of all jobs with parts in and vehicles out

I have a sample code that i use on another sheet but all it does is email a link to that spreadsheet every morning, i want this one to me more targeted and actually email them rows from the spreadsheet individually.

Is this possible?

Many thanks.

A few questions for clarification:
-I don't see any email addresses on your sheet. Do you want the email address to remain blank in the email?
-How do we know who the "managements team" is?

Post the code you are currently using. Remember to use code tags when posting the code.

My apologies, I have updated the example with the emails. Column I displays an email based on an IF statement and the managers emails are in cell M2.

I have played about with your code and it seems to work well, Thank you so much.

I have a couple of questions though,

If I leave the email cell blank, the code stops working. Because I don't want to send an email to everyone who has parts in and only the service advisors, is it possible to adapt the code to pass if it see's a blank cell?

Is it possible to have the email sent automatically i.e, I'd like to send an update to the service advisors (all emails in column I) every morning but only send to the Management team on a Sunday morning (middle east so sunday is the first working day of the week).

I would also like to send a full breakdown of spreadsheet to the commercial vehicle dept.
Is it possible to do something like, IF B2 = "C" THEN email all lines that apply rather than just "all parts available"

Thank you

The code has been updated to deal with Blank email lines. I also added a button to execute the email summary to management. Reviewing your other requests.

For

I would also like to send a full breakdown of spreadsheet to the commercial vehicle dept.

Do you want a button to send the table contents only when Column B contains a C?