I need to write some code to do the following:

If the value in A1=$5000.00 then open Lotus notes and send an email to a
specific person with the subject title: Overage

I will also need to apply this to other cells with other amounts.

Any thoughts?