I did read through this..

http://www.sqlservercentral.com/scripts/Miscellaneous/31733/

but I can't work out how I would loop through the list of people requiring emails and parse the parameters and emails from my sql query 🙁