Sql-server – Replace the server name in email sender address when sending email from SQL Server 2008

database-mailsql serversql-server-2008

I'm sending emails directly to Microsoft Outlook accounts from SQL Server 2008. Everything is fine, email was sent. Only problem is that in the header of the email the SQL Server name is embedded.

I've tried specifying the @from_address when executing the mail sending in DB but the sql server name is still there in the email's header. I don't want my recipients to see the sql server name in the header.

Is there a way to block this?

Thanks much!

Best Answer

Try creating a new database mail profile and database mail account. Put the email address you desire as the name of the new mail account. Then use the profile when calling the stored procedure to send email: EXEC msdb.dbo.sp_send_dbmail
@profile_name = "DB Mail Profile"

Cheers!

Related Question