Solved

Send Recurring Emails

Posted on 2001-08-30
8
258 Views
Last Modified: 2012-05-04
Is there a way we can specify to send an email to a specific address without user intervention.  For example:
If I need to order a roll of paper towels every week on Tuesdays at 10:00 am every week.  I have the body of the email, the receipients email.  Is there a way I can just send this email based upon the schedule given without user intervention every time an email has to go out?
0
Comment
Question by:amira123
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +1
8 Comments
 
LVL 2

Expert Comment

by:prokni
ID: 6443095
If you have Sql Server, I would use sql to send an email in this way you can create a job and schedule it.
0
 

Author Comment

by:amira123
ID: 6443228
I don't have a ssql server ... is there another way?
0
 
LVL 7

Expert Comment

by:TheNige
ID: 6443343
you can create a vbscript that does them mail then schedule it with the windows program scheduler
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
LVL 2

Expert Comment

by:prokni
ID: 6443462
He is right, write a exe vb application and put it in task schedule in windows. use CDO or cdont for email
0
 

Author Comment

by:amira123
ID: 6443606
"He is right, write a exe vb application and put it in task schedule in windows. use CDO or cdont for
email"

How do I do that?  I am not fimiliar with VB.
0
 
LVL 20

Expert Comment

by:Silvers5
ID: 6443641
How do I schedule ASP files?


Use the AT command and Windows Scripting Host to schedule a VBS file at certain intervals.
 
First, change the ASP to a VBS file. This is accomplished by (1) changing the extension to VBS; (2) changing all server.createobject calls to createobject; and, (3) removing all <%%> delimiters and any browser-destined code (for example, response.write statement or client-side HTML). I didn't run into any further complications, but YMMV.
 
You store the VBS file in the filesystem, and use the AT command to schedule it (this actually schedules its execution with NT's schedule service). At a command prompt, you can use AT by itself to see a list of tasks currently in the schedule. You can use AT /? to find out all its syntax possibilities.
 
For example, to get a file to run every weekday at 9:00 am, I launch this batch file (the first line clears existing entries):
 
    at /delete /y
    at 9:00 /every:m,t,w,th,f d:\net\shared\getdata.vbs
 
 
 
Notice there is no web server involved; the file is accessed directly through the file system. Once I got over the "a user has to be logged in" and "the tasks have to be reset when rebooted" hurdles (both of which I believe are problems with the particular machine that is not under our control), all has been running fine for me.


this is for vbs.. if using a VB put simply a counter in it or simply check th time.. if it's between certain values you fire your event..

with this use a mail component to email "email records" from the db..

   
[ Main Category: e-mail | Secondary Category: components ]

How do I send e-mail from ASP?

There are several components that enable you to do this. You may already have one, if you have an SMTP server installed alongside IIS - it's called CDONTS. Here is the documentation and an article for CDONTS:
 
    http://msdn.microsoft.com/library/psdk/cdo/_denali_newmail_object_cdonts_library_.htm 
    http://www.aspfaq.com/faq/faqShow.asp?fid=49 
 
There are also several other components available (if I missed any, let us know)
 
    Genusa's AspMail
    http://www.serverobjects.com/products.htm#Aspmail 
 
    ASPEmail
    http://www.aspemail.com/ 
 
    Dundas Mailer
    http://www.dundas.com/index.asp?/products/mailer 
 
    MailListBot
    http://www.MailListBot.com/ 
 
    EasyMail
    http://www.easymailobjects.com/emobjects/smtp.asp 
 
    w3 Jmail
    http://www.dimac.net/ 
 
    HTMLMailer / HTMLMailerPlus
    http://www.oopadelic.com/htmlmailer/ 
    http://www.oopadelic.com/htmlmailerplus/ 
 
    DevMailer
    http://www.geocel.com/devmailer/ 
 
    VSEmail
    http://www.vsoft-tech.com.au/vsemail/readme.html 
 
    Mabry Mail
    http://www.mabry.com/mail/index.htm 
 
    NNTPClient+SMTPClient
    http://www.liquidcool.com/asp 
 
    SimpleMail
    http://www.adiscon.com/SimpleMail 
 
    AB Active X Mailer
    http://www.geocities.com/ResearchTriangle/2656/abmailer.html 
 
    OCXMail
    http://www.flicks.com/aspmail/ 
 
    WindMail
    http://www.geocel.com/windmail/ 
 
    Zaks.POP3
    http://www.zaks.demon.co.uk/code/cpts/pop/index.html 


 
 
0
 
LVL 7

Accepted Solution

by:
TheNige earned 100 total points
ID: 6443655
you don't have to make a vb exe.....just make a vbscript file...using the same code much like you would in regurlar asp....but they you need to use the windows scripting host so that you can run the vbscript in the command prompt.  You will then have a file named something like thisfile.vbs.  Use a program scheduler to run that file....

look up the windows scripting host on the MSDN site for more help
0
 
LVL 20

Expert Comment

by:Silvers5
ID: 6527125
what i said differently?? amir (a) explain please..
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Query still returning duplicates 5 58
Connection to multiple databases 13 44
Filktering Alphabetically 8 46
Prevent certain words from being typed in a form 6 54
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question