Hi,

1-Remove 'webmail.'

2-The data result of the query need to be strings. For date or numeric field, use convert() function

Daniel

exec sp_send_MailHtml

'smtp.entech.us', --SMTP Server

'sharad@entech.us', --From

'jatin@entech.us', --To

'sharad@entech.us', --CC

'', --CCi

'Test Page', --Subject

'select top 2 Field1,Field2

from superaccesslevels..totaldatabase'