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.