I'm trying to create a database of products and their stock levels.  That's not difficult, but now I've hit a problem: I'd like to have an email sent automatically to a particular address (or maybe a few addresses) when the stock level of a product gets down to a certain level.  All the email would to contain, apart from the address would would be a product name and the stock level.  The recipient would then order more.  Can thi

Hi,

As far as I know, Access has no build-in feature to reach your goal. Some VBA code may be another choose, I'll move your question to the MSDN forum for Access

http://social.msdn.microsoft.com/Forums/en-US/home?forum=accessdev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

George Zhao
TechNet Community Support

Hi Dividers,

You could create Data Macros in MSAccess to send emails, it's just like the triggers in SQL Server.

https://support.office.com/en-us/article/Create-a-data-macro-b1b94bca-4f17-47ad-a66d-f296ef834200#__toc264895168

Firstly use the IF-ELSE macro to determine if the stock level of the product gets down to a certain level, then call SendMail macro to send emails.