getting info out of an email automatically...

[albie101]

Ok, not sure if this can even be done, and if it can I have no idea where to start so any help would be appreciated!

I am working on an internet site where any number of people can send in reports that need to be displayed on the site. Ideally we would like users to be able to send in an email with the appropriate subject and attachment and somehow be able to recognise that the email has arrived, get the attachment and put it in the database.

As I said, I don't really have any idea on how to tackle this one, so any thoughts or insights would be great!

Thanks
Emma

 

[vasah20]

Emma -
The only way that I can think of to do this (without creating a daemon to monitor the mailbox) would be to use SQL Server Agent, and have it check a mailbox at given intervals. I know that you can use SQL Mail to mail out emails, I don't know if you can monitor it though...

You really can't do it using ASP code... unless you create a WSC and NT Scheduler, which would allow you to effectively monitor the mailbox. For realtime monitoring, you would need to create a daemon for that.
hth
leo

------------
Leo Mendoza
lmendoza@students.depaul.edu

 

[albie101]

Thanks Leo. Thats pretty much what I thought. Thanks for the reply though.

Em

 

[ToddWW]

Hey, don't give up so fast. Have you thought of placing an ASP script that allows your visitors to attach files to a web page and submit them to the server. Otherwise known as a file uploader ?? It's supported and there are many free ASP scripts that you can download over the web that will provide you with everything you need. Start at

http://www.learnasp.com

TW

 

[albie101]

I've used file uploaders before and it is probably the track I'm going to go down. I would have rathered using email as there are loads of people who are going to be using this and they would prefer to send an email rather than having to log on and upload files, but it doesn't look like I have much choice without a load of work I don't have time to do...

Thanks for the reply!
Em