Email Query Results sp_send_dbmail

As an attachment

EXEC msdb..sp_send_dbmail

    @profile_name = 'SQLMail Profile',

    @recipients = 'email@email.com',

    @subject = 'Report',

    @query = 'EXEC dbo.Sproc',

    @attach_query_result_as_file = 1,

       @query_result_separator=',',

       @execute_query_database = 'DatabaseName',

       @exclude_query_output = 1,

       @query_attachment_filename = @FileName,

       @query_result_no_padding = 1