Send automatic emails based on cell text within a column

[Pedroc12]

Hi i hope you can help me since i have been trying this for weeks.

I need to find a way for excel to send an automatic email to a specific adress IF any value from a column changes its value to a specific text. The value in question is text, so for example:
- If C5 changes to "Done" then an email is sent to a specified adress.

Thank you and have a nice day!

 

[SanjayGMusafir]

You can do that with HYPERLINK Formula
For what you want to achieve, you have to create a column that changes message body as per your requirement - IF or IFS Formula can help you with that.
Similarly you can create "Customised" Subject Column too, if needed.
The generic formula is underneath. You can customize it as per your needs.

=HYPERLINK("mailto:" & C3 & "?subject="&IF(D3=1,$I$3,IF(D3=2,$I$4,$I$5)) &"&cc=abclimited@abc.com"&"&body="&IF(D3=1,$J$3,IF(D3=2,$J$4,$J$5&E3)) & " " &$J$7, "Send email")