...

View Full Version : automatic email



fogofogo
09-22-2005, 01:33 PM
Hi Folks,

I have been asked to try and write a program that basically pulls some info from a sql database and automatically emails it to an email address on a certain day of the week :confused:

So if anyone can offer advice or if they know of any script or tutorials online, I would be very grateful if you could let me know

Thanks

J

nikkiH
09-22-2005, 03:04 PM
You need a program that can be scheduled, not one that runs from the web.
ASP is not for this.

Use VB6, VB.NET, Java, or another independent language that can compile to an exe that can be scheduled via Windows scheduler or *nix crontab (depending on what computer it runs on).

Bullschmidt
09-22-2005, 08:29 PM
Automating Tasks with WSH by Mark Lidstone - 10/13/1999
http://www.4guysfromrolla.com/webtech/101399-1.shtml

How do I schedule ASP files?
http://www.aspfaq.com/show.asp?id=2143

And here's a nice CDO link even if you don't use the attachment part:
Email (with Attachment)
http://www.asp101.com/samples/email_attach.asp

nikkiH
09-22-2005, 08:48 PM
*snaps*
Oh, I forgot Windows can run vbs files like exe.

Still kinda misleading of them to say you can schedule asp files, though, when you have to change it all to wsh code.

Bullschmidt
09-22-2005, 09:06 PM
Still kinda misleading of them to say you can schedule asp files, though, when you have to change it all to wsh code.


Good point.

Or code could be written so that the first time a user comes to the site on the designated day an e-mail is sent and also a LatestEmailSentDate field is updated so that no more e-mails are sent on that day.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum