Send email if cell contains specific text

I need to generate and automatically send an email if a cell contains specific text. The text will be EE or Vodafone or 3.

Is this possible?

Thanks for this. Pardon my ignorance though but how do I change this to specify precise entries into a cell to generate the email rather than just a change to the cell value?

I'm sure I must be doing something wrong but this isn't working.

I need emails to be generated if EE, Vodafone, Three are entered into cell D20. There will be multiple email reipients but I can change those.

When I amend this and test, nothing happens however when I debug and run the email is generated so appears to be a problem being triggered with the cell value entered.

In D20 I would enter either EE, Vodafone or Three.

But I have tested your code with entering 0, 30 or 60 into C18 and still it doesn't appear to work. Ignore what I have in my spreadsheet as I can amend it to match the cells I need referenced. It's just not generating emails when I enter the values from your original code.

Attached. Just need to add an email address to E18

I think we're at cross purposes here.

What I am looking for is when I enter either EE, Vodafone or Three in a specific cell (call it C18) then an email is generated. I can amend what is contained in this email.

What your code is doing is meant to generate an email based on day ranges from 0, 30 or 60. I understand what this is doing and that it can be amended to match my requirements. BUT by copying your code, placing it in a module within my workbook and testing. It does not generate an email when any of those values are entered into C18.

If you are able to provide me with the workbook with your code that works then perhaps I'll be able to amend this for my own needs?

Thanks for this but I have already found both of these suggestions myself online and neither really answer the question I'm asking for. My first job (as should everyones) before posting on here is to Google an answer I then come here to find an expert who is able to assist if I can't self troubleshoot the problem.
I don't think it's a very tricky request I just can't get the syntax right for it to work.
Are you able to assist?

As discussed

This now works