Post reply

Set Dynamic from address in Sp_Send_DbMail

  • April 13, 2010 at 1:10 pm

    #221321

    I am using Sp_Send_DbMail to send the mails. Everything works fine. But When we try to change the from address from code it wont allow and also through the error "@from_address is not a parameter of Sp_Send_DbMail ". How can I set Dynamic from address in Sp_Send_DbMail. If you know pl sharewith me.

    Thanks

    Ananth

  • April 13, 2010 at 1:15 pm

    #1150988

    sananthakumar (4/13/2010)

    I am using Sp_Send_DbMail to send the mails. Everything works fine. But When we try to change the from address from code it wont allow and also through the error "@from_address is not a parameter of Sp_Send_DbMail ". How can I set Dynamic from address in Sp_Send_DbMail. If you know pl sharewith me.

    Thanks

    Ananth

    According to BOL, @from_address isn't a parameter for sp_send_dbmail.

    The Redneck DBA

  • April 13, 2010 at 1:19 pm

    #1150991

    You have to configure a different profile for each sender.

    Converting oxygen into carbon dioxide, since 1955.

  • April 14, 2010 at 7:31 am

    #1151327

    sananthakumar (4/13/2010)

    I am using Sp_Send_DbMail to send the mails. Everything works fine. But When we try to change the from address from code it wont allow and also through the error "@from_address is not a parameter of Sp_Send_DbMail ". How can I set Dynamic from address in Sp_Send_DbMail. If you know pl sharewith me.

    Thanks

    Ananth

    It will be fine , when you send mail then change disply name before that by query, and then send mail.

    Creating new profile every time is not good.

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply