Email Trigger

[Michael 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]

Michael,

FYI: Usually one thanks a fellow poster for responding and then clarifies
the question with a response and does not repeat the post on another day,
this way the message is threaded and perhaps others can learn from the
discourse...

Warm Regards,
Dan