Post reply

xp_sendmail query in subject line

  • May 10, 2006 at 12:56 pm

    #112075

    Using xp_sendmail, is it possible to put a query into the subject line.

    I know how to put a query into the text of the email but we have a case where a query in the subject would identify how high a priority the email actually is.

     

    Thanks

     

    David Weil

  • May 10, 2006 at 1:16 pm

    #637096

    Do you want the results of the query in the subject line ?

  • May 10, 2006 at 1:18 pm

    #637097

    Yes

    thanks

  • May 10, 2006 at 11:38 pm

    #637154

    DECLARE @Subject varchar(4000)

    SELECT @Subject = MyField FROM MyTable

    EXEC xp_sendmail 'me@mydomain.com', @Subject

    Andy

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

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