Did you ever get resolution to your question?



Seems to me that if you want periodic email to go out you would need an 

application that runs on the server.  Otherwise you would need an ASP page 

that is open all the time and watching the clock.  The only problem with 

this is you probably want some sort of user authentication to prevent 

unwanted people from snooping and then you get the problem of session time-

outs.



I suggest you set up a periodic task on your calendar as a reminder and do 

it manually.



Just a few thoughts,



-doug



> Hi there,

> 

> I'm not sure whether this is a VB question but would appreciate any 

> pointers: can I use CDONTS to automatically send out email at regular 

> intervals, e.g. every 24 hours or once a week etc., without my 

> intervention?  (I want to send the results of a database query via email 

> where the results change regularly).  

> 

> I know CDONTS can send the email automatically as a 'one-off' but don't 

> know if it can be used for these regular, timed-interval mailings.  Am I 

> looking at a VB/3rd-party component to do this?  What would be the 

> better/best solution?

> 

> Thanks for any feedback.

> 

> Jake

Do it manually?  What is this, the stone age?!! ;-)



windows script host is what you want.  Take the ASP that contains the

functionality that you want, remove all HTML and any references to the ASP

object model (Request, response etc, also replace Server.CreateObject with

CreateObject), so that your left with a "raw" script that does what you want

and nothing else.  Rename the file with a .VBS extension (or .JS if its

javascript). Now to test the script, just double click the file on the

server, or open the command line and type 



cscript.exe "C:\path\script.vbs"



Once you are satisfied that it works properly, you can schedule it using the

AT command (Type AT /? in the command line for help)



e.g. (from my memory, not sure if this is exactly the syntax)



to run on the 1st of every month:



AT /every:1 cscript.exe "C:\path\script.vbs"



to run every monday and friday:



AT /every:M,F cscript.exe "C:\path\script.vbs"



Incidentally, I've been a member of these lists for about a year, and this

must be about the 100th time I've answered this question!





-----Original Message-----

From: Doug Powell [mailto:doug.powell@a...]

Sent: 16 January 2002 16:39

To: ASP CDO

Subject: [asp_cdo] Re: CDONTS





Did you ever get resolution to your question?



Seems to me that if you want periodic email to go out you would need an 

application that runs on the server.  Otherwise you would need an ASP page 

that is open all the time and watching the clock.  The only problem with 

this is you probably want some sort of user authentication to prevent 

unwanted people from snooping and then you get the problem of session time-

outs.



I suggest you set up a periodic task on your calendar as a reminder and do 

it manually.



Just a few thoughts,



-doug



> Hi there,

> 

> I'm not sure whether this is a VB question but would appreciate any 

> pointers: can I use CDONTS to automatically send out email at regular 

> intervals, e.g. every 24 hours or once a week etc., without my 

> intervention?  (I want to send the results of a database query via email 

> where the results change regularly).  

> 

> I know CDONTS can send the email automatically as a 'one-off' but don't 

> know if it can be used for these regular, timed-interval mailings.  Am I 

> looking at a VB/3rd-party component to do this?  What would be the 

> better/best solution?

> 

> Thanks for any feedback.

> 

> Jake






________________________________________________________________________

Scottish Enterprise Network

http://www.scottish-enterprise.com



Headquarters Address & Contact Numbers



150 Broomielaw

5 Atlantic Quay

Glasgow

G2 8LU.

Tel:  +44 (0) 141 248 2700.

Fax:  +44 (0)141 221 3217



 This message is sent in confidence for the addressee only.

It may contain legally privileged information. The contents are not to

be disclosed to anyone other than the addressee. Unauthorised recipients

are requested to preserve this confidentiality and to advise the sender

immediately of any error in transmission.

Alex,



All well and good, but your solution is what I originally said requires an 

application running on the server.  Setting up a scheduled task is fine if 

you are the server owner/administrator.  



But, if you are using some other hosting service, another solution has to 

be found.  



Regards,



-doug

OK...



Well in that case what you can do is keep the functionality in an ASP, then

write a script to run on your own PC which opens an instance of IE or

Netscape, and calls the URL.  This script can then be scheduled to run on

your own PC, no need to bother with any manual actions.



-----Original Message-----

From: Doug Powell [mailto:doug.powell@a...]

Sent: 16 January 2002 17:18

To: ASP CDO

Subject: [asp_cdo] Re: CDONTS





Alex,



All well and good, but your solution is what I originally said requires an 

application running on the server.  Setting up a scheduled task is fine if 

you are the server owner/administrator.  



But, if you are using some other hosting service, another solution has to 

be found.  



Regards,



-doug








________________________________________________________________________

Scottish Enterprise Network

http://www.scottish-enterprise.com



Headquarters Address & Contact Numbers



150 Broomielaw

5 Atlantic Quay

Glasgow

G2 8LU.

Tel:  +44 (0) 141 248 2700.

Fax:  +44 (0)141 221 3217



 This message is sent in confidence for the addressee only.

It may contain legally privileged information. The contents are not to

be disclosed to anyone other than the addressee. Unauthorised recipients

are requested to preserve this confidentiality and to advise the sender

immediately of any error in transmission.