Post reply

xp_sendmail question

  • June 30, 2008 at 9:33 am

    #193933

    I have a question regarding parameter to xp_sendmail. Instead of defining multiple recepients one by one can we select a distribution list that was setup in the outlook. If so how, please tell it by example. Thank You in advance.

  • June 30, 2008 at 9:51 am

    #836227

    yes you can, just as you would with a single mail address...

    @recipients = 'DBAGroup@MyCompany.com'

  • June 30, 2008 at 8:37 pm

    #836428

    Yes you can just input the group message

    Exec master.dbo.xp_sendmail

    @recipients = 'Group@Acme.com',

    @message = 'have a nice day',

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

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