Sending an email automatically based on criteria in cell

Copper Contributor

Hello!

 

I need to create a way to send an email automatically to the same three recipients when a new row in this spreadsheet is updated and  Column L is  marked "yes" from the dropdown menu. I have tried to use Power Automate to the best of my ability, but am not getting anywhere with it.  Any suggestions on either a VBA or Power Automate?

 

CHeatley_0-1715603980016.png

 

1 Reply
Content of mail "send an email"