email from excel

[saravanan2021]

Hi,
In attachment, I have an code which sends email to the person once the value in column B reaches >200 as on sheet name "MoreThenOneFormulaValueChange"

I need small correction and I am not able to do it.

In sheet "New requirement", I have added one more column L "Target"

I need code to be modified, if the value in Colum B reaches above the value in Column L.

e.g.
If B3 is greater than L3 send email
If B4 is greater than L4 send email
If B5 is greater than L5 send email
If B6 is greater than L6 send email
If B7 is greater than L7 send email

Also the code running till 7th row of the data.

I may add many column in future. Hence the code should run till end of the data range in column A.

[Richard Buttrey]

Hi,

Try this code
Note the reference to Sheet3 is the VBA sheet CODE name for the tab name "New Requirement", Change that as necessary if your production workbook is different.

Please Login or Register  to view this content.

[saravanan2021]

Hi Richard,
Thank you very much for your code. Need one more modification.

Once email sent then it does not send email again for same records.

Hence modification need to be done if any time number gats changed whether in column B or Column L and if value in B is greater than L in specific row email to be sent.

You can remove the code for Status in column C

[Richard Buttrey]

What do you mean by 'the same records'. The macro displays all five emails for the five records. Have you changed the .Display to .Send?

[saravanan2021]

Yes I have changed the .Display to .Send

I am sorry. Same records means, eg. B2 is > L2 (after changing the any number in B2 or L2 and the result is B2 > L2) then send email.

[saravanan2021]

hi richard,
Can you help me on this?