473,326 Members | 2,126 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Automated Email

I need to send an automated email each day (Member expiration
notices). The data sits in an SQL Server but SQL Mail is not
available.

Building an .asp page that makes this happen isn't a problem, but that
page would have to be loaded each day for the process to run.

Any ideas on how to make this happen?

Thanks

Brett

Nov 8 '07 #1
6 2196
Brett_A wrote on 08 nov 2007 in microsoft.public.inetserver.asp.general:
I need to send an automated email each day (Member expiration
notices). The data sits in an SQL Server but SQL Mail is not
available.

Building an .asp page that makes this happen isn't a problem, but that
page would have to be loaded each day for the process to run.

Any ideas on how to make this happen?
1 call it from a scheduled task on a client pc of yourself.

or

2 if the time inplat is low, and you have enough regular visitors,
run it on the homepage of the first visitor every day after say 7 o'clock,
ansd store the fact it is run that day somewhere in a file or the database.
--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
Nov 8 '07 #2
Brett_A wrote:
I need to send an automated email each day (Member expiration
notices). The data sits in an SQL Server but SQL Mail is not
available.

Building an .asp page that makes this happen isn't a problem, but that
page would have to be loaded each day for the process to run.

Any ideas on how to make this happen?

Thanks

Brett
Set up scheduled job and use this activex:

Dim WshShell
Set WshShell =CreateObject("WScript.Shell")
WshShell.Run ("http://www.yourwebsitecom/yourpage.asp")
Set WsShell = Nothing

It works nicely for me.

Steve
Nov 8 '07 #3
On Nov 8, 11:17 am, Dooza <stev...@SPAM.dooza.tvwrote:
Brett_A wrote:
I need to send an automated email each day (Member expiration
notices). The data sits in an SQL Server but SQL Mail is not
available.
Building an .asp page that makes this happen isn't a problem, but that
page would have to be loaded each day for the process to run.
Any ideas on how to make this happen?
Thanks
Brett

Set up scheduled job and use this activex:

Dim WshShell
Set WshShell =CreateObject("WScript.Shell")
WshShell.Run ("http://www.yourwebsitecom/yourpage.asp")
Set WsShell = Nothing

It works nicely for me.

Steve
Steve,

Can you point me to more information about how to do this?

Thanks

Brett

Nov 8 '07 #4
"Brett_A" <br********@gmail.comwrote in message
news:11*********************@i38g2000prf.googlegro ups.com...
I need to send an automated email each day (Member expiration
notices). The data sits in an SQL Server but SQL Mail is not
available.

Building an .asp page that makes this happen isn't a problem, but that
page would have to be loaded each day for the process to run.

Any ideas on how to make this happen?
Why not take the code in the ASP page put it in a VBScript file and set up a
scheduled task to execute it daily.

Control Panel | Scheduled task | Open
File | New | Scheduled Task

Rename the task to something sensible.

Open properties of task

For task to run browser to system32\cscript.exe then add the the filename
of the vbs file as a parameter.

Set Start in to the folder the VBS file is in. Configure Run as for the
user that task should run as.

Other settings are pretty self explanatory.
--
Anthony Jones - MVP ASP/ASP.NET
Nov 8 '07 #5
Brett_A wrote:
Can you point me to more information about how to do this?
Hi Brett,
In Enterprise Manager expand the Management Tab, then the SQL Server
Agent Tab and click on Jobs. Now right click on Jobs and create a new one.

Give it a name, and then click on the Steps tab. Click on New, name the
step and then select Active X Script from the type list. Copy and paste
the code into command text area and amend the script to suit your page.
When done click ok and then go into the schedule tab and set it up
correctly.

That should be all you need to do.

Steve
Nov 9 '07 #6
On Nov 9, 4:01 am, Dooza <stev...@SPAM.dooza.tvwrote:
Brett_A wrote:
Can you point me to more information about how to do this?

Hi Brett,
In Enterprise Manager expand the Management Tab, then the SQL Server
Agent Tab and click on Jobs. Now right click on Jobs and create a new one.

Give it a name, and then click on the Steps tab. Click on New, name the
step and then select Active X Script from the type list. Copy and paste
the code into command text area and amend the script to suit your page.
When done click ok and then go into the schedule tab and set it up
correctly.

That should be all you need to do.

Steve
Thanks Steve, I give that a shot.

Brett

Nov 13 '07 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Bengt Richter | last post by:
I find that threads sometimes mention PEPs that I wasn't aware of, or that an interesting one has been updated without my noticing. I should perhaps check the PEP site more regularly, but ISTM it...
3
by: SueHales | last post by:
Hi, folks. I'm fairly new to SQL Server, so forgive any stupidity inherent in this question. I work at a university and a certain faculty member would like to have her students create a simple...
4
by: MLH | last post by:
I would like to configure OutLook Express so that it does not attempt to resend eMails in the Outbox folder whenever new sends are made From Access. The ISP's server rejects some eMail address...
6
by: brettev | last post by:
World, I work at a university where the professors have a system to input grades for assignments and calculate final grades, which is output to an excel file. they are then required to get on a...
2
by: tk | last post by:
Hello, At the moment im building a database for a driving school, I have a customer field, with email address as an attribute. I dont know much about macros in access but once the customer has...
0
by: tonydevlin | last post by:
I currently have the python code obj=sti.object creator = obj.Creator() history = sti.getHistory() wf_tool = context.portal_workflow mMsg = """ Content has been submitted for your review....
7
by: Jeff | last post by:
Hey ..NET 2.0 I'm on a project where I'm now about to develop the Data Access Layer. The database have 300 stored procedures. I'm about to go on a time consuming process of writing the .NET...
1
by: jadeverell | last post by:
Hi, I have a database that contains information of contracts / tenders and need to do the following task: * when a contract reaches its expiry date, i want to send an automated email to notify...
1
by: jadeverell | last post by:
Hi, I have a database that contains a list of contracts including the dates they are due to expire and i was wondering if Access can be set up to send an automated email to an email address that...
12
by: mr_marcin | last post by:
Hi Does anybody have some idea how to input some text into inputbox on one page, than press some button on that page, that will load another page, and finally read the responde? Suppose I want...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.