Email condition to active Members

[Accounts_Team]

Good day,
I hope all is well.
I created a sheet of “Orders” and another sheet called “Team”
I need help to SEND AN EMAIL WITH 2 CONDITIONS IN 2 DIFFERENT TABLES:
_The first condition is based on status of the sheet “Orders” (I created an enum status that needs to be switched to “Open Bid” so the email can be sent after saving);
_The second condition is to select the emails of the “Active” Teams only in the other sheet. (I created an enum status of the Teams that has “Active” and “Inactive” options)

I am sorry to disturb, its been a week of confusion and couldnt get it well in my head. Please help