E-mail trigger

[azjeepster]

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.

 

[solex]

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.