Hi,

we can send out a mail using the built in SP for SQL 2005. The syntax for the same is as follows

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'Profile',

...