Email to SQL

[lmt_blue]

Hi

I am designing an online IT HELPDESK program and would like users to be able to email a specific address and the email details (sender, date, subject, body) be inserted into a SQL database.

I am running:

Exchange Server 2000
Outlook 2003
MS SQL 2000

I have seen this done using VB6 but all new projects have to be done in VB.NET. I am a little stuck as I am new to VB.NET so in need of assistance or at least to be pointed in the right direction.

Thanks in advance

Lee

 

[TechGnome]

Best bet would be to create a Windows Service component that runs on the SQL server checking the mail box. When something comes in, read the email and insert the data in to the database. Then delete the email.

-tg

 

[lmt_blue]

Hi

Thanks for responding, that is the sort of direction I would like to go in, but have no idea where to start!!!!!!

Would you be able to point me in the right direction???

Thanks

Lee