Writing a .net app to pull the dataset and iterate through it sending the mails would be faster than doing it in SQL, especially as merging the html template will involve some substring / replace activities (which in volume SQL isn't very fast at).

Depends on your volumes of course, if you are sending only a few thousand at a time a cursor or while loop would probably be fine.