Thanks it solve my problem

and i want to give example

how to use for person like me

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'Account',

@recipients = 'email@domain.com',

@query =

'Declare @date smalldateTime

SET @date= CAST(CAST(YEAR(GETDATE()) AS VARCHAR(4)) + ''/'' +

CAST(MONTH(GETDATE()) AS VARCHAR(2)) + ''/01 05:00:00''

AS smallDATETIME)

Select Column1,Column2,

(

select Count(1)

from DatabaseName.dbo.TableName1

where Column1=DL.Column1

and Column23=2

and ColumnDate>= @date

and ColumnText<>''SomeText''

) as CountColumn

from DatabaseName.dbo.TableName2 as DL',

@subject = 'Subject ',

@attach_query_result_as_file = 1 ;