1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

User response to Database Mail

Discussion in 'Programming/Internet' started by Henry Laney, Oct 8, 2018.

  1. Henry Laney

    Henry Laney Guest

    I'm doing some high level planning of an application at the moment. When a bcp import finishes, I'm going to send an email using Database Mail.

    I'd like the email to have options or filters for the recipient. Their choices will determine which particular SQL scripts kick off.

    For example:


    from: database@mail.com

    to: henry@mail.com

    Import has completed, would you like to:

    +------------+---------+
    | Update | Find |
    +------------+---------+​

    My intuition was that I could make the choices mailto links, to populate the body of a response email. But I haven't been able to find any resources on triggering an alert when receiving an email. In fact, the diagram I found below suggests to me that you actually can't reply to Database Mail:

    [​IMG]

    Has anyone ever worked on a project like this?

    Login To add answer/comment
     

Share This Page