In the database I have built I have an alert when this alert is triggered I want it to send out and email alert as well. Hod do I tie my these together?
Advanced Beginner
Windows XP 
Access 2002
In the database I have built I have an alert when this alert is triggered I want it to send out and email alert as well. Hod do I tie my these together?
Advanced Beginner
Windows XP Access 2002
The code for my alert is as follows and does what is should do. Now I want to have it send out and email alert as well once the preceeding is meet.
If me.units_in_stock < me.minimum_qty or me.units_in_stock = me.minimum_qty then
me.order_qty= me.required_qty - me.units_in_stock
Moderator
Windows XP Access 2003
see this site for examples
http://www.blueclaw-db.com/access_em...nd_outlook.htm
Program Link to Outlook Email from a Buttom
Posting Permissions
Reply With Quote