found a way...thanks anyway guys..

IF (select count(*) from [e009]) > 0

begin

exec msdb.dbo.sp_send_dbmail

@profile_name = 'Default',

@recipients = 'me@example.com',

@subject = 'warning',

@query = 'select * from [e009]',

@attach_query_result_as_file = 1,

@query_attachment_filename = 'warning.csv'

end