Retrieve Email details from Exchange 2003 and insert into SQL

[Vika]

I have an Intranet site for IT Help Desk in classic ASP with a back end in SQL 2000. I also have an email account Helpdesk for external users to send requests and problems. What I am trying to do, is read all incoming emails from the Helpdesk email account and insert the Subject, Body, Received Date and Sender Email address into the SQL 2000 database, and move this email to a sub-folder under the Inbox folder of Helpdesk email account called "Complete". All of this needs to run as a job on a schedule in SQL Server.

Note: The SQL Server 2000 and Exchange 2003 are on 2 separate servers, but on the same domain.

Could somebody point me in the right direction as to how this could be accomplished?

Thank you!!!

 

[mrdenny]

Look into xp_readmail in Books Online. There is a sample procedure included with SQL 2000 called sp_readmail which will show you how to use it.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Vika]

The xp_readmail is for reading Emails in SQL inbox. I have Exchange Server handling the emails, not the SQL server. I would think that it should be some kind of sp or an API call to the Active Directory.

 

[mrdenny]

If you want to read from a mailbox other that the SQL Server mailbox you will need to write an application or service that runs outside of SQL Server.

I would recommend having the help desk mailbox forward all it's emails to the SQL Servers mailbox so that you can have the email processed by the SQL Server directly.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com