How might I create a macro that detects when a field is changed from one
status to another and automatically either creates a popup to a webaddress or
sends an e-mail?

For example: In the Status field, You can select yes, no or maybe. If the
value is changed from yes to no, I would like macro to automatically detect
this and create a questionnaire e-mail or to link to a website.
Any help would be greatly apppreciated.