Hi.
I need a sub routine that sends email when specific fields are amended. I already have a general send mail on modify_success but I need to trigger specfic emails when values are amended in particular fields. They also need to be or statements as mutipl fields may be amended.
I guess it's:-
If field was "frog" and is now "toad"
then email message
or if field was "tree" and is now "flower"
then email message
or if field was "cabbage" and is now "lemon"
then email message
else
carry on with modify_success
any clues anyone please?
I need a sub routine that sends email when specific fields are amended. I already have a general send mail on modify_success but I need to trigger specfic emails when values are amended in particular fields. They also need to be or statements as mutipl fields may be amended.
I guess it's:-
If field was "frog" and is now "toad"
then email message
or if field was "tree" and is now "flower"
then email message
or if field was "cabbage" and is now "lemon"
then email message
else
carry on with modify_success
any clues anyone please?