Email connected user on record change/addition

I would like to be able to email a specific user based on a connected record's value.

I have a system that tracks bug reports, and the bug reports are assigned (connected field to users). Each bug report has comments (a connected object - many comments to one bug). I would like to send an email to the assigned user of the bug whenever a comment is made, but it is not an option.

Seems like a pretty standard type of scenario. Thanks for considering!


I would also like the ability to auto-send an email when data changes.

Yes, the ability of forms to send e-mails to specific users or user groups is very important - we shouldn't have to re-write apps when we have staff changes or assignment of responsibilities changes.