It is fairly simple to do - you need to create an "ON UPDATE" trigger on your table (a) that pulls the data you want to send into either a temp or permanent table (b) (doesn't really matter which).
THen all you need is a windows scheduled task that will go through (b) and send the emails out.
It's also worth getting the scheduled task to flag the rows of (b) when the emails have been sent, just to ensure they're not sent twice.