Macro for Automatically send email, based on the change in the cell value of all cells in a single column

[SenthilR]

i am looking for Macro for Xl 2007 to send emails which are listed in column A automatically, when the numeric data in column D changes to "4". I am looking for this as i have to mail each one of the people listed in column A, each time the cell value gets to "4". and i need the macro to have the row for which the mail is sent to copy and paste it in the body of the mail.

the body of the mail should be same for everybody. "FYI/A
your segment is nearing deadline of "5 days".

and another macro for sending mail to the ID listed in column A, to send mails, when New data is added in column C. copying all the new data posted for that mail ID.

Thanks in advance

 

[VoG]

You are asking a lot but this may get you started Send a mail when a cell reaches a certain value

 

[jai Yadav]

i am looking for Macro for Xl 2007 to send emails which Send a mail when a cell reaches a certain value
That i want to use if my cell A1 valve reaches equal to cell N4 value then its auto generate mail and sent it to following address in cell P2.
The value in cell A1 is getting from a formula i.e (B1+C1-D1).
Please help me to make it so that i can continues study in this system.

Thanks in advance