Email Trigger

[Mike Jacobsen]

Scenario:

Access 2000
Exchange Server 2000

User A enters Record 1, including filling in Field X. Data of Field X
happens to be the username of an actual Exchange 2000 email user. As a
result of the event, an email needs to be sent to the username to alert of
the change. Also, should User B decided to edit Field X of Record 1 to a new
username, an email needs to be sent to the new username to alert of this
event. The email ideally would be a form. How would I accomplish this? I am
a beginner Access person, so please be specific. Thank you.

 

[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.