SQL Mail reply address

  • Does anyone know of a way to controll or change the reply to address for an email sent via SQL mail?

  • You have to change the address at the mail server (for all mails).

    Alternatively, you can use CDO/CDONTS to generate the mail.

    Steve Jones

    steve@dkranch.net

  • Thanks for your reply.

    Do you know if I can I use CDO/CDONTS from within the SQL Query analyzer?

    quote:


    You have to change the address at the mail server (for all mails).

    Alternatively, you can use CDO/CDONTS to generate the mail.

    Steve Jones

    steve@dkranch.net


  • You can use the com object calls to use it.

    If you want to use xp_sendmail you can stop the mail service and start it again with a different return address - I think it's xp_startmail and xp_stopmail


    Cursors never.
    DTS - only when needed and never to control.

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

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