Automatic Email Generation !

[Waheed2008]

Hi all,

I have got a situation. I have made an Inventory database and have maintained available stock quantity in a table field "StockQty". I have another field in the same table "MinimumQty" which keeps minimum quantity required in stock, like MinimumQty=5. It shows that if available Stock Quantity is less than or equal to the Minimum Quantity, we shall go for new purchase.

Now I want that whenever such situation occurs, (Available Stock in Inventory decrease the minimum quantity), an email should be generated automatically and sent to specific address giving him notice about it. How to implement this functionality? Any help, Please!

Regards

 

[ajetrumpet]

here is a useful link:

http://www.access-programmers.co.uk/forums/showthread.php?t=181932

 

[irish634]

Here's another useful link:
http://www.access-programmers.co.uk/forums/showthread.php?t=164429