hello there
can any one give an idea on how to send automatic mails for example i have on the database names emails and birthday i whant that i day befor anyones birthday it recibes an automatic email.
i whant it that the script doit for itself any idea????

thanks


Visit my home page
www.cancuncoral.com

Hi Jaime

The way I got around this to create a fully automatic service is to use windows scheduler with a vbs file, otherwise you'll have to create a asp page and run it yourself everyday.

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>

u can schedule an asp page to load with a piece of software that opens up the webpage at a certain time .. i forget the name of it but im sure google will have the answers

I did something similar a few years ago for a client just using an asp page and the windows scheduler. It's a bit of a fudge but might do for your purposes:

open task scheduler from start &gt; programs &gt; accessories &gt; system tools &gt; scheduled tasks
click on add scheduled task
click next
select internet explorer
click next
select perform this task daily
click next a couple of times
check the box that says 'open advanced properties for this task when i click on finish'
click finish

This will bring up the advanced properties. In the box which says "Run: " enter the following:
C:\PROGRA~1\INTERN~1\iexplore.exe -nohome www.mysite.com/scheduler.asp

then you just need to add the code into your page called scheduler.asp and if you include a bit of javascript at the end which says:

&lt;script&gt;window.close()&lt;/script&gt;

then this will schedule you asp page to be opened in IE once a day, run the asp script, then close the window down again.


Alertnatively, you could write your own compiled .exe in visual basic or java or similar which polls the current time and executes some code on a schedule, but this sounds too much like hard work to me(!)


Just remember, you need to leave this machine switched on at the schedule time for it to work properly.



Edited by - mykeblack on 14 Jul 2005 17:18:46