asked on

Store incoming/outgoing mail in SQL Server 2000

Hi, please help me with this as I'm going nuts trying to find an answer.

We need to develop an application that stores all email, that is received through a specific email address, in SQL Server. What I'm looking for is a script that exports certain fields into a table when a message is received. I know that GFI already does this but this is not an option since the way it is stored in SQL Server sucks ass and we can't change it.

Hope to hear from you soon!

jdhoover123

I don't suppose you could use an inexpensive Linux box as your MX relay, bring all email into it first, and use the Milter package to save out the parts you need into a MySQL or PostgreSQL server? The mail would just foward on to the "real" mail server when finished.

Hoov

aquadis

ASKER

No sorry, this is not an option. The only software I have is Exchange 2003, en Windows Server 2003 and buying other soft- and/or hardware is not an option for this client. Come on guys/girls, is this too difficult for you (it is for me...)??

jdhoover123

Here's somewhere to start... http://www.developersdex.com/gurus/articles/429.asp

Hoov

ASKER CERTIFIED SOLUTION

jdhoover123

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jdhoover123

Yep, after further reading, this sounds like the way to go. Basically use SQLMail to create an Inbox for the SQL Server, and route your email address to that Inbox (either directly or sending a copy there). From there on, not too horrible - the second URL is the easiest to get through.

Hoov