DTS to take data from my outlook inbox and save it as textfile

• mmatseke

  Ten Centuries

  Points: 1129

  More actions

  May 4, 2004 at 9:17 am

  #359636

  Hello everyone

  I need quote or some information on how to take data from my email and save it as a textfile on my C:\ drive.  I only have two things to use DTS and SQL.   I need all information since i am newb

  Thank you in advance

   

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  May 4, 2004 at 9:42 am

  #505153

  You can research xp_readmail from BOL however, I don't think this will work for you.

  The SQL server can read mail sent to the SQL server but, I haven't heard of it being able to read someone else's e-mail inbox.

  I would research doing this via VB that could look at your e-mail or possibly create a RULE that would EXPORT your mail on receive.

   

  Good Luck

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net

• philcart

  SSC-Forever

  Points: 47795

  More actions

  May 4, 2004 at 7:12 pm

  #505227

  Take a look at creating something in DTS using VBScript to reference CDO objects.

  EG:

  Set objSession = CreateObject("CDONTS.Session")

  objSession.LogonSMTP ("Joe Friday", "joe@here.com")

  Set objInbox = objSession.Inbox

  Set colMessages = objInbox.Messages

  MsgBox objInbox.Name & " – " & colMessages.Count & " messages"

  The actual folders accessed depend on it's being run against the SMTP service of IIS or Exchange Server.

  --------------------
  Colt 45 - the original point and click interface