Send E-Mail TO SQL Server

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • lhansen
    #1

    Send E-Mail TO SQL Server

    I have a SQL Server 2000 application that send's e-mail to users using
    the xp_smtp_sendmai l procedure. That works fine. What I would like
    to do is RECIEVE e-mail with SQL Server.

    Example: I text message an alert to a user. They reply with some
    keyword in the subject of their reply e-mail, such as 'ACKNOWLEDGED'
    or 'ACK' for short. SQL Server recieves this and then acts upon it
    with a stored procedure, etc.

    Anyone know if this is possible and with what tool?

    TIA,

    Lindsey
    Tags: None
    • Simon Hayes
      #2
      Re: Send E-Mail TO SQL Server

      lindsey.hansen@ fmc-na.com (lhansen) wrote in message news:<c358d596. 0401151315.37bb 4298@posting.go ogle.com>...[color=blue]
      > I have a SQL Server 2000 application that send's e-mail to users using
      > the xp_smtp_sendmai l procedure. That works fine. What I would like
      > to do is RECIEVE e-mail with SQL Server.
      >
      > Example: I text message an alert to a user. They reply with some
      > keyword in the subject of their reply e-mail, such as 'ACKNOWLEDGED'
      > or 'ACK' for short. SQL Server recieves this and then acts upon it
      > with a stored procedure, etc.
      >
      > Anyone know if this is possible and with what tool?
      >
      > TIA,
      >
      > Lindsey[/color]

      If you set up SQL Mail, you can use sp_processmail to handle incoming
      emails. Although if you're using xp_smtp_sendmai l, then presumably SQL
      Mail may not be an option for you.

      Although I don't know of an existing tool, it should be relatively
      easy to write a script which connects to a mailbox, parses the emails
      and then connects to SQL Server to do something there. You can then
      schedule it to run at a suitable interval (every 5 minutes or
      whatever), or make it into a service.

      Simon

        Comment

        • lhansen
          #3
          Re: Send E-Mail TO SQL Server

          Thank you for your response Simon. One question, though, would that be
          a vb script that I would write?



          *** Sent via Developersdex http://www.developersdex.com ***
          Don't just participate in USENET...get rewarded for it!

            Comment

            • Simon Hayes
              #4
              Re: Send E-Mail TO SQL Server


              "lhansen" <lhansen@nospam mmmmm.com> wrote in message
              news:4008034e$0 $70303$75868355 @news.frii.net. ..[color=blue]
              > Thank you for your response Simon. One question, though, would that be
              > a vb script that I would write?
              >
              >
              >
              > *** Sent via Developersdex http://www.developersdex.com ***
              > Don't just participate in USENET...get rewarded for it![/color]

              Any language with support for handling emails and COM objects would work, so
              you could use VBScript, Perl, Python, C# etc. I'd pick the language that you
              are most comfortable with, and that you have other resources/skills for in
              your organization.

              Simon


                Comment

                Previous template Next
                Working...