I created a database in MS Access for tracking some financial documents. I am trying to find a way to automatically email me when a record has be outstanding for X number of days. Does anyone know how I could achieve this with a macro or VBA?
Other suggestion would be setup a stored proc in SQL to send email via through the proc but you would need logic in Access still to tell it when it needed to fire off the proc.