Send email based on field value
I have an Inventory database that has a field called "Quantity On Hand". When a user enters "1" into the field I want an email sent out (via smtp), so that stock could be re-ordered. Does any on have a script or method for doing this. All I need is a email that has a subject line that say "Order part number" and the actual part number pulled from the appropriate field.