Hi

on our server we are looking to set it up so that emails that are address to a certain email address somehow get inserted into a row in a SQL server database. But we have been scratching our head for quite some time now and the best thing we can come up with is paying some on to copy and paste them in manually. Does anyone know of a better way? I think we have to stick to micrsoft mail server as well.

An advice would be greatly recieved.

__________________
Sorry spelling not my strong point!

You will have to make a script and run it as a cron job. Don't ask how because I can't answer it, but someone else may be able to

__________________
Wildfire Marketing Forum - Visit our free marketing forum to learn and share tips about marketing.

I have an asp email mailing script that I use to send hotel special offers to clients. You can add/remove new clients or mark them as "inactive". It uses an MS Access database though rather than SQL - could you modify it? Send me a PM if you are interested.

Cheers,
Paz.

__________________
10.3 million entries for Hotels in Turkey but I'm still chipping away.

The answer could be with your email client. If you use Outlook for an email client, it's programmable. It's object model is not easy however. I haven't done what you ask, but I've customized other Microsoft Office apps like Powerpoint and Word. It's called VBA code. I hope this gives you ideas.

__________________
jedicoder
current seo efforts on Website Designer Search Directory and Grand Oak eCommerce Web Designer

An email that adds a record to a data base?

__________________
OverSite - A unique web directory for quality sites ONLY.

ive never done this on a MS machine, but on linux:

1. use an alias to pipe the email address to a script
something@here.com | /home/site/www/email_input.php

2. use stdin() in email_input.php to grab the contents of the email

3. use pear:Mail_Mime to parse the email into digestible sections plain text, rtf, html, attachemnts etc.

4. insert relevant parts into the db

I created a proof of concept a long time ago so i could see if i could make a site that would allow me to upload images via email. It works, most of the time, RC

The answer you want is within SQL Mail on SQL Server 2000.

You need to setup the SQL Mail and SQL Agent mail. Once done, you can even fire queries at your database via email, to which the SQL Server will email you the results - completely automatically.

Anyway, once your got SQL Mail setup, you just need to decide what you want SQL Server to do when it recieves the emails in question. I normally do it with triggers.

Here's a link to set you on the right road (SQL Server will do everything you need):

http://www.databasejournal.com/feat...cle.php/3345091

__________________
www.bsolveit.com
Web Design & SEO for Business Growth