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.

[TABLE="width: 101"]
<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>[TR]
[TD="class: xl66, width: 80, bgcolor: transparent"] L [/TD]
[TD="class: xl66, width: 32, bgcolor: transparent"] M [/TD]
[TD="class: xl66, width: 22, bgcolor: transparent"] N[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]Total Points[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Sally[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]2.0[/TD]
[TD="class: xl65, bgcolor: transparent"]Sally[/TD]
[TD="class: xl67, bgcolor: transparent"]2.0[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Dave [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]0.0[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Mike [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]3.0[/TD]
[TD="class: xl65, bgcolor: transparent"]Jack [/TD]
[TD="class: xl67, bgcolor: transparent"]3.0[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Larry [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]0.0[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Ben [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]0.0[/TD]
[TD="class: xl65, bgcolor: transparent"]Ben [/TD]
[TD="class: xl67, bgcolor: transparent"]3.0[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Ron [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]0.0[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]




I would be extremely grateful for any suggestions.