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

...

This script is working on SQL 2000 / Windows 2003 server.

I do not test it on other configuration.

But I suppose that that should work.

Daniel Eyer