E-mail trigger

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to setup a trigger that would send an e-mail message to a
user/group in Exchange 2000 based on a new record added to a Access 2000 DB.
The event would be as follows:

User creates new record A, and Field X is filled in with particular user
name 1. As a result of Field X being filled in with the user name 1, the
user needs to receive an e-mail notifying them of this event. Additionally,
if the newly created record A is updated in the future, an e-mail needs to be
sent to the changed user name 2 to notify them of this event. I would also
like to make the e-mail as a form, and one for each event (new record,
changed record). I am a beginner with Access (know networking well, novice
programmer).

How would I do this? I am a beginner at Access.
 
It all depends on how you are updating the underlying table.


One suggestion would be to use an unbound form to modify the record
contents, and then create a procedure to add/update the underlying table.
This procedure can then interrogate the username field and send an email if
appropriate.

I would also make sure that this procedure is the only access point for this
tables additions and updates.
 
Back
Top