Excel to send automated email based on certain criteria

[Dannytt93]

Hello,

I am looking for a way to get excel to send an automated email based on whether a certain criteria has been met.

IF C12 = Completed THEN send email to "Email Address", containing text "Text body" to "recipeint email"

Any help would be greta if it is possible, i think it has to be done in VBA

Thanks

Dan