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.