Database Mail - Multiple queries within sp_send_dbmail.

Hi guys,

I was wondering if anyone had any luck running multiple queries within sp_send_dbmail.

What I would like to do is either :
1. Attach more than 1 attachment, each being the result of different queries ,or
2. Attach these results in different sheets within my excel attachment that is being sent via sp_send_dbmail.

Thanks for you assistance.

Regards,

Vinay