Hi

one possible solution is to use an SSIS Package

1) Add task to select dataset 1 and store in a csv flatfile (excel)

2) Depending on how many pieces of data in your summary data and how you want to display this in the email body gather the dataset2 data

a) for once piece of info use an Execute SQL and save it to a variable

B) for multiple pieces store the data in a recordset

3) use a scripttask to build the email body variable

4) use a sendmail task with an attachement

You can schedule this package to run as and when needed

Paul