How to display two mail Id using database mail to recipient

• avdhut.k

  SSCrazy

  Points: 2834

  More actions

  August 21, 2013 at 12:58 am

  #282211

  Hi,

  I had configured the database mail, using my Mail ID.

  So, when I send the mail to reciepient,it displays my mail ID.

  Now, My requirement is,I don't want only my mail ID to display.

  we have a Email Id for our department.But I don't want to configure a database mail account using my department email id.

  Is there any way ,so that we can display to the receipient's "from" as email-id on behalf of department email id.

  Please help me!!

  Thanks in Advance!!

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  August 21, 2013 at 1:21 am

  #1643338

  Have you seen the @from_address and @reply_to parameters of msdb.dbo.sp_send_dbmail?

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• avdhut.k

  SSCrazy

  Points: 2834

  More actions

  August 21, 2013 at 4:07 am

  #1643374

  Hi,

  I just checked that this parameters,

  my requirement is fulfilled by @from_address parameter.

  I have also tried @reply_to, but I didn't understood.

  Thanks very much for the help!!!!