Read email using SQL

• Iggy-SQL

  SSCarpal Tunnel

  Points: 4169

  More actions

  May 8, 2006 at 7:31 pm

  #97064

  Hi, I'm using SQL 2000, can I read email? I've seen the script "HTML Email Using SQL" and this is for sending, I'm thinking receiving should be not much different, except some parameters need changing (e.g., change OUT to IN)?

  I've had a look at sp_processmail but this is to process query sent via email, which is not what I want. What I want is to capture the content/body of the email messages, and store it in the database (together with the sender and subject).

  Can this be done? thanks in advance.

  ---

  Urbis, an urban transformation company

• May 11, 2006 at 8:00 am

  This was removed by the editor as SPAM

• texpic

  SSCertifiable

  Points: 5887

  More actions

  May 11, 2006 at 9:27 pm

  #637437

  I use something called Email2DB  ...  I'm pretty happy with it although have issues every now and then.  About a $350 piece of software.