Question Locked

Access 2003 email - automated based upon choice or criteria

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello all, thank you for being a wonderful resource for those of us learning Access 2003.

I am attempting to send an email, automatically, from Access 2003. This requirement has the following criteria:

1. The email must be sent to addresses that are listed in a table.
2. The email must be sent based upon a filter function of certain issues we face (i.e., tears goes to address "A", voids go to address "B", etc.)
3. A report is run daily that parses the catergorical information and needs to determine which "failures" are above a certain limit, and then email based on those failure rising above said limit.

Any assistance is beyond appreciated.

John

2 replies

by larryd4

Best bet is to write a VBA and attach to an event and send the email with a small SMTP command line sender.

Baically create an event on push. on set focus, on exit, whatever you want to use that compiles the information you want to send and then sends it via an external SMTP send app that can reside in the same folder as your database.

Something like this...
http://www.beyondlogic.org/solutions/cmdlinemail/cmdlinemail.htm

This discussion is closed to new replies.