see if you can use procedure sp_send_dbmail

where you can change your Subject of email according to requirement

and append your server name or address