Generate email response from database.
October 26, 2006 2:37 PM   Subscribe

Is there a free simple web to email gateway or scriptable email responder that will run on windows server 2003?

I need to generate an email report based on the subject of a recieved email (an id number) and send it back the the requester. And I need to check the requester's email address against a user database.

The website already generates the same report on a web page, but web access is not always available to my users. The report has to be generated upon request, it can't be generated on a schedule.

The mail server is the very simple one built into windows server 2003. I don't have access to Exchange or anything like that. I thought of just watching the mailbox directory and triggering a program when a message showed up, but I don't have the windows programming skills to do that.

The easiest thing would be to load the web page, save it, and send it back as an attachment. Is there an easy way to do that? The web is full of autoresponder programs for spammers that do nothing at all like what I need.
posted by Nothing to Computers & Internet (3 answers total)
 
From a technical standpoint I'm 99% sure that this can be done.

To do what you wish to do with Windows 2003 built-in mail server it sounds like a custom programming job. I believe that incoming messages are placed in a folder and you could poll that folder for new messages and if found parse the message for a sending e-mail address, compare that e-mail address to a database, then send back the appropriate report based on the e-mail address.

If you're currently serving up these reports on the web via SSL then you would probably want some sort of security on the e-mail side.

Also, it's very easy to spoof e-mail addresses so someone could send to your mail server as someone else and a person who didn't request a report could get one. To avoid that you may need additional info to be included in the e-mail message to verify the sender's identity.
posted by dgeiser13 at 2:56 PM on October 26, 2006


Call a local consultant. You just need a programmer to write a windows service that runs headless and does this thing for you.

Get someone you can communicate with and someone you trust. Pay the going rate because you get what you pay for.
posted by mrbugsentry at 6:20 PM on October 26, 2006


Response by poster: I finally found this to monitor a directory and set it up to call a batch file.
posted by Nothing at 7:49 AM on November 1, 2006 [1 favorite]


« Older TSA rules make no sense! Surprise!   |   How is the volume of a 6 oz tea cup measured? Newer »
This thread is closed to new comments.