Copying emails to another SQL database

[SpenBabe]

One of our clients requires their membership system extending so that all emails sent & received regarding a member's email address be referenced or stored in the SQL database that hosts the core data.

Is there some product/technology out there that could allow us to either create of copy of the email in another database automatically or perhaps create a intermediate file which we could pick up via DTS/SQL Job/Scheduled Task, bearing in my that some members send HTML mail & some send plain text.

The code for membership system is written in Visual C++ 6.0, so I looked at MAPI but it looks like a whole world of pain to me !!!



Spencer Window (not a joke name)
spencer.window@eastmidlandcomputers.ltd.uk

 

[TimStokes]

I am after somethign similar... Here's what I posted to microsoft.public.exchange.development...

----------

Hi all,

I'm trying to set up an auto response for anyone who emails a
specific address at our company (e.g. '...@example.com') saying
thanks for your message, and click here to register on our website.


However, we only want to send an auto response to people who are not
already registered on our site.


So, what we want to do is have Exchange insert into a temporary table
in our MS SQL database, which our ASP script will then loop through and
work out if it needs to send an auto response.


How can we get Exchange to write to the database every time a message
is received to '...@example.com'?


Do we need to write an application that will plug-in to Exchange, or
Outlook, to do this?


I look forward to hearing your ideas and advice!


All the best,
Tim