Classic ASP Discussion - Feeding a Web Site via Emails

Print Page | Close Window

Feeding a Web Site via Emails

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=3775
Printed Date: 30 March 2026 at 10:06am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Feeding a Web Site via Emails

Posted By: Misty
Subject: Feeding a Web Site via Emails
Date Posted: 23 June 2003 at 8:37pm

I have a potential client who is interested in feeding a web site via emails. For example, when the person sends an email to mailto:list@anywhere.com - list@anywhere.com , it posts the email to the web site as dated content. The web site itself would just be a series

I have never done this before. Can anyone tell me how this might be accomplished?

Replies:

Posted By: the boss
Date Posted: 23 June 2003 at 9:00pm

u need some component like JMAil to read the POP3 mailbox and detect new mails. and then read the required details from the mail like date, subject, body, etc etc etc and insert them in the SQL database,.. download the jmail manual and developer guide from http://www.dimac.net - www.dimac.net and u will undertstand how this can be done..

u can also use ASP POP3

also the asp page coded to read the mail and insert in the database should run on a routine..

there r some pop3 software which can directly insert the mail in the SQL database

Posted By: Misty
Date Posted: 28 June 2003 at 11:02am

Has anyone ever done this before? Does anyone know of any example codes that might help?

Posted By: the boss
Date Posted: 28 June 2003 at 7:07pm

http://www.dimac.netthey - www.dimac.net
They got examples and reference for jmail..

http://www.jmailbox.org - www.jmailbox.org
there is a complete POP3 mail client built in ASP using Jmail and it is available for download free of cost..

http://www.serverobjects.com/products.htm#AspPop3 - http://www.serverobjects.com/products.htm#AspPop3
ASP POP3 from Server objects..

doin this with ASP POP3 is much easier and asp pop3 cost less than jmail..

Posted By: michael
Date Posted: 28 June 2003 at 9:42pm

this is still not dynamic as you would have to run the asp page at all times. There are some options that have a mail handler integrated with a database system. There are ways with Exchange Server and SQL but I do not know if this is something you can do with your isp

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: the boss
Date Posted: 28 June 2003 at 11:53pm

ms exchange integrated with sql servet is not an always or easy available option.. it as well cost a lot to.. a company might be providing hosting solution and would be running exchange server as well sql server but when it comes to integrating both.. it becomes expensive..

doin this in asp would be much cheaper provided that u run the asp file containg the code on regular time bases like ever 10 min or so.. if u hostin agrees to set the system sheduler to run that asp file after ever certain time interval.. that would be great..

and i guess there r some ways in making a WSH application which would execute a webpage / app after countinusly after a certain time interval but WSH files r required to be registered on a server just like dll files..

Posted By: ljamal
Date Posted: 29 June 2003 at 3:23am

Assuming that you are using SQL Server it is not necessary for the script to be on the web server. You could create a VBscript file and run it on any machine with Internet access and the POP3 component. You could then schedule the file to run without needing to schedule it on the web server. My suggestion would be to use a reliable machine (or several machines) to insure the update happens.

Additionally, you could have the an ASP page on the server start the process. Assuming you get regular traffic to the home page of the web site you could have it set off the process every 10 minutes. This would mean there would be less updates during the web sites lower periods, but there are also likely to be less email updates during that time as well. Also, if no one is veiwing the site, is there really a need to do the update?

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming

Posted By: the boss
Date Posted: 29 June 2003 at 6:04am

updates r REALLY necessay in any condition so search engines may discover it and bring some unique traffic.. and yes ljamal is is right that the ASP page can be sheduled to run from ur local machine or u can upload the page to hosting and still shedule ur local computer to run it..thats like more viable option as it will keep the site safe from hackers threat and reduce ur webserver load as well save bandwidth too..

Posted By: ljamal
Date Posted: 29 June 2003 at 6:12am

A web spider is a viewer and thus would force an update, so even if an ASP page (such as your default page) kicked off the update, the spider would get the most recent information. If you are going to run the schedules locally then I would recommend writing a VBScript file and runnning it as you will be able to run it on any Windows machine as long as the proper POP3 component is installed.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming

Posted By: Bluefrog
Date Posted: 29 June 2003 at 9:50am

There was an article on EXACTLY this in the January 2002 MSDN magazine. Check the magazine website for the code. http://msdn.microsoft.com/msdnmag/ - http://msdn.microsoft.com/msdnmag/

It's on updating SQL Server with Outlook. You can then do the rest as normal.

Posted By: Bluefrog
Date Posted: 29 June 2003 at 9:55am

http://download.microsoft.com/download/msdnmagazine/code/Jan02/WXP/EN-US/OutlookSQL.exe - http://download.microsoft.com/download/msdnmagazine/code/Jan02/WXP/EN-US/OutlookSQL.exe

That's the code link.