sending email when certain condition met

[Bluedaz30]

Hi

i have a spreadsheet whereby i have a formula in column AE which needs to be converted to a number in column AI ( i have the code for this) once this has been done i then need to send to a single email address ie [email protected] when number 4 is present in column AI the range needs to cover the whole of column AI and will have blanks and multiple numbers within the column, at any point in the column there is a 4, i need an email sent
i have attached the spreadsheet i am referreing to.
im hoping some one will be able to help

[Leith Ross]

Hello Bluedaz30,

Welcome to the Forum!

You haven't provided enough information for anyone to answer to question. There are several critical pieces of information missing about this email like to whom it is being sent, the subject of the email, and the email message itself. Are you using Outlook as your email program or something else?