Send email when some action

Hi gents, i have a script to manage the registered users on my site. have also a table with id, name, uname, passwrd, email, datejoined, level and status my question is... it there any possibility to inform a member by mail that his (let'say) current status changed from inactive to active, or from active to inactive? I mean, whenever a change occur on member's details, a mail is sent to him telling what was changed. Any posssibility? Miguel