Generate excel and send as attachment using dbmail in SQL Server

Hi Team,

I am trying to send email from SQL server. However i am able to send email from sql server but i want to send excel as attachment which will generated in the fly with Query result.

It means in mail send SP it generates excel file from SQL query result output and send the same as attachment in email.