declare @body1 nvarchar(MAX)
set @body1 = N’
:: Report(1-06-2011 To 30-06-2011) ::
First Name | Last Name |
---|
‘
print @body1
EXEC msdb.dbo.sp_send_dbmail @recipients=’sunil@iglobeconsulting.com’,
@subject = ‘My Mail Test’,
@body = @body1,
@profile_name = ‘Prakash Rathod’,
@body_format = ‘HTML’ ;