Send reminder Email from Access when Due Date is past

[sgiuffrida]

I am currently running Access 97 and am trying to have my employee database send a reminder email to employees who have come past due on their annual physical. When the appointment date is past due it would automatically send the email from access via a Groupwise email system and advise the employee of the missed appointment.

Does the database have this functionality and what scripts or books do you suggest i use to get this project complete...


Thanks
Steve

 

[shuff]

I do something like this currently when a deadline date passes in my project management database.

I created a separate database named "Apprentice." Apprentice has an OnTimer event that updates a form with the correct time every few seconds. The table containing the project dates is linked to Apprentice, and a macro linked to the OnTimer event checks the time. In the macro, (for example), if the clock time reads 06:30, a dependent macro is fired that goes out to the projects table, checks records with expired deadline dates, runs a report that shows the projects withe expired dates, then emails the report as a Snap .SNP file via SendObject to the group owning the project. You could individualize this logic to send to just one person rather than a group.

And because Apprentice is a standalone utility, it can be leveraged in this and many other databases we've produced that require autoemail reminders or alerts. Very flexible. It just sits out there watching the time, firing macros at appointed times for appointed tasks.

Hope this helps,
SLH

 

[sgiuffrida]

Thankyou for the information, It is a great help. This solution should work well for my case. When i build the acceptence database i am simply linking to the original database that contains the due date and patients names, correct? This all happens with Macros and no need to write additiona VBA to customise the solution, correct? if so we are looking very good on this fix..

Thanks
Steve

 

[shuff]

Yes, it all happens in the macros. I rarely write code in Access because I am able to do about 99.5% of everything I need in objects rather than crankin' code...

SLH

 

[jereece]

Can someone post a simple demo of this. I have a Task database and want to send an email to the owner when their task goes past due, but am unsure how to do this. If I could see an example, I think I can make it work with my database.

Thanks for any help...

Jim

 

[shuff]

About Apprentice Timed Events Utility

Jim, I have done a quick-and-dirty page on how my utility works. Hope it helps. Attachment is in .pdf format.