Sending an email automatically based on criteria in cell

Copper Contributor



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?




1 Reply
Content of mail "send an email"