How to specify the reply-to address using sp_send_dbmail in SQL Server

Question

I need to send an email to someone and want them to be able to simply reply to the email without having to specify the email address.

Using sp_send_dbmail sets the reply-to address as the name of the profile that it was sent from.

Can this be changed to specify the reply-to so it looks like it came from me.

Thanks.

Answer 1

Not in sp send dbmail itself

The reply address is just text and can be set up in the profile.

Eg I configure [email protected] but the email account is [email protected]

Hit reply and it goes to [email protected]

So, configure your profile used by the sp thus to show this.

The line saying "The e-mail address to show on outgoing e-mail messages." here

sp send dbmail help. no parameter for reply address