Trying to edit the display name when sending an email

Question

Hello All,

I have created a database profile and finished setting up the database mail.Right now my subject is AMC SQL ALERTS and I am trying to change this to AMC SQL ALERTS_WHD_BACKUP...I have changed this in display name..But I am still getting the same AMC SQL ALERTS when email has been sent..Please help..

Thanks

Answer 1

Hi Srisql,

Do you want to change the subject line? How did you change the subject name? 

You can try to send a test mail and manual change the subject line for the email in the subject box. Or you can test email from SQL Server to execute the statement below likes:
declare @body1 varchar(100)
set @body1 = 'Server :'+@@servername+ ' My First Database Email '
EXEC msdb.dbo.sp_send_dbmail @recipients=’’,
    @subject = 'My Mail Test',----change the subject line here
    @body = @body1,
    @body_format = 'HTML' ;

For more information, please refer to Troubleshooting Database Mail: Sending Test E-Mail

If you changed success please verify subject line message using  sysmail_allitems. For  more information, please refer to this article.

---

Regards, Amber zhang