none
Database Mail Issue

    Question

  • Hello All,

    I have an issue with database mail.I have given the profile name as test backup and the account name as test_backup.Everything is working fine.When I send an email I want to add the description to my from address like SQL ALERTS_servername.Rightnow I am having only SQL ALERTS.I have added this description to my profile.It is working fine when I send the test mail to my email address,But I am not getting this description when I am sending to group email.Please note that the email address I have provided in the database mail is same as the group email.

    Please help.

    Thanks

    Thursday, March 15, 2012 8:22 PM

Answers

  • Hi

    Try to send out an email using msdb.dbo.sp_send_dbmail  to a gmail or hotmail address and check if you got the description. If so then check with your SMTP Administrator because it could be removing the description from the incoming emails


    Javier Villegas | @javier_villhttp://sql-javier-villegas.blogspot.com/

    Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

    Friday, March 16, 2012 11:37 AM

All replies

  • Did you add the description to group profile?

    http://uk.linkedin.com/in/ramjaddu

    Thursday, March 15, 2012 8:32 PM
  • Yes I have added. I tried sending the test email from group profile to my company email id and it is working fine. But when I am sending the email to group email I am not getting the description what I want.
    Thursday, March 15, 2012 8:44 PM
  • what is your group email format?  are you using group email address like this adc@abc.com? 

    http://uk.linkedin.com/in/ramjaddu

    Thursday, March 15, 2012 8:51 PM
  • Yes.It is like this abc_sql_alerts@abc.com

    Thursday, March 15, 2012 8:55 PM
  • Hi

    Try to send out an email using msdb.dbo.sp_send_dbmail  to a gmail or hotmail address and check if you got the description. If so then check with your SMTP Administrator because it could be removing the description from the incoming emails


    Javier Villegas | @javier_villhttp://sql-javier-villegas.blogspot.com/

    Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

    Friday, March 16, 2012 11:37 AM