Here is a demo that shows how multiple resultsets can be embedded in an email with SqlAnswersMail.
The first resultset is a list of products. Notice that no coding was required to render the images {Query1}	Another resultset displays a list of orders side-by-side with products. The functionality to embed multiple resultset is unique to SqlAnswersMail -- it's not available in other mail utilities such as xp_sendmail. {Query2}
The final resultset contains a list of Northwind's top performers for the year. To get more information about SqlAnswersMail, please visit us at www.sqlanswers.com. {Query3}