send separate email each time a change is found in a range of cells

[timlh42]

I have employee names and accumulated points in column L The points are in the row directly below the name. I have a macro that will display the name in column M and the point total in column N once the value hits 2 or 3 or 5.

I would like to automatically generate a separate email every time a cell in column N reaches one of those numbers.

However, I don't want to resend an email that was already sent.

In other words..... if Sally, listed in column M row 3 has reached 2 points, listed in row 3 column N then an email gets sent. Later on, Jack, listed in column M row 7 reaches 2 points, listed in row 7 column N then an email gets sent about Jack.

I don't want another sent about Sally. However, If Sally then later reaches 3 points, I want another email sent about Sally but I don't want another one sent for Jack.

Here is a sample of the spreadsheet.

L	M	N
Total Points
Sally
2.0	Sally	2.0
Dave
0.0
Mike
3.0	Jack	3.0
Larry
0.0
Ben
0.0	Ben	3.0
Ron
0.0

<colgroup><col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;"> <col width="32" style="width: 24pt; mso-width-source: userset; mso-width-alt: 1170;"> <col width="22" style="width: 17pt; mso-width-source: userset; mso-width-alt: 804;"> <tbody> </tbody>

I would be extremely grateful for any suggestions.