A friend would like to have a signup form on his site. Anyone that
signs up will be entered into a database and automatically sent an
email report. This much I can do!
However, he'd then like the person to recieve a further 2 reports with
a specified delay (say a week) between each email. He'd like this
process to be automated - sending anyone who signs up the three reports
with a week between each emailing.
Any ideas on how this is achieved much appreciated! A script on the
server?
Many thanks,
OP 7 1685
On Wed, 24 Jan 2007 18:40:59 +0100, odysseyphotogra phy
<in**@odysseyph otography.netwr ote:
A friend would like to have a signup form on his site. Anyone that
signs up will be entered into a database and automatically sent an
email report. This much I can do!
However, he'd then like the person to recieve a further 2 reports with
a specified delay (say a week) between each email. He'd like this
process to be automated - sending anyone who signs up the three reports
with a week between each emailing.
Any ideas on how this is achieved much appreciated! A script on the
server?
Indeed, run a cronjob, which checks what emails to sent, and does the
sending.
--
Rik Wasmus
* I'm testing several new newsreaders at the moment. Please excuse
possible errors and weird content. *
odysseyphotogra phy wrote:
A friend would like to have a signup form on his site. Anyone that
signs up will be entered into a database and automatically sent an
email report. This much I can do!
However, he'd then like the person to recieve a further 2 reports with
a specified delay (say a week) between each email. He'd like this
process to be automated - sending anyone who signs up the three reports
with a week between each emailing.
Any ideas on how this is achieved much appreciated! A script on the
server?
Many thanks,
OP
I'd set up a cron job to run once a day. Have it scan the database and
based on whatever criteria you select send the email.
--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp. js*******@attgl obal.net
=============== ===
odysseyphotogra phy schreef:
However, he'd then like the person to recieve a further 2 reports with
a specified delay (say a week) between each email. He'd like this
process to be automated - sending anyone who signs up the three reports
with a week between each emailing.
As already mentionned, read the cron manual
Any ideas on how this is achieved much appreciated! A script on the
server?
Using http://www.swiftmailer.org/ you can reduce your work...
--
Tim Van Wassenhove <url:http://www.timvw.be/>
Tim Van Wassenhove wrote:
odysseyphotogra phy schreef:
>However, he'd then like the person to recieve a further 2 reports with a specified delay (say a week) between each email. He'd like this process to be automated - sending anyone who signs up the three reports with a week between each emailing.
As already mentionned, read the cron manual
Really, at a trivial level 'at' is much more apposite however with smart
batch handling, cron might be easier.
Also you need to authenticate requests through the email address - usually
this is done by emailing back a response to a prompt. For that you will
need a mailbox with procmail setup in front of it or a cron job polling the
mailbox.
C.
On Wed, 24 Jan 2007 23:40:23 +0100, Colin McKinnon
<co************ **********@ntlw orld.deletemeun lessURaBot.comw rote:
Tim Van Wassenhove wrote:
>odysseyphotogr aphy schreef:
>>However, he'd then like the person to recieve a further 2 reports with a specified delay (say a week) between each email. He'd like this process to be automated - sending anyone who signs up the three reports with a week between each emailing.
As already mentionned, read the cron manual
Really, at a trivial level 'at' is much more apposite however with smart
batch handling, cron might be easier.
Also you need to authenticate requests through the email address -
usually
this is done by emailing back a response to a prompt. For that you will
need a mailbox with procmail setup in front of it or a cron job polling
the
mailbox.
Why doesn't a single email with a 'click on this link to confirm', and a
flag in database suffice? This setup seems a little overly complicated.
--
Rik Wasmus
* I'm testing several new newsreaders at the moment. Please excuse
possible errors and weird content. *
Thank you all so much.
OP
For anyone who can't set up a CRON job, and justs needs a quick and
easy solution - this might work:
<img src="http://www.urlhere.com/script.php" alt="script" width="1"
height="1" border="0" /> This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Limey Drink |
last post by:
Hi all,
Firstly :-) , is there any where I can search through archived newsgroup
posts so I am not cluttering up the newsgroup with repeated queries ?
And secondly :-), I know this has probably been discussed before but.
I am wanting to do some scripting to automate a few administration tasks,
one of the first tasks is automating FTP file transfers.
|
by: xzzy |
last post by:
I need to automate a report in a different database (and thank yous to Terry
Kreft for pointing me in the right direction).
below is the code with the one line that does not work, marked: 'Does not
Work'
It appears that the type of object returned from the "AllReports" collection
is not a report object.
=>> I need it to be an object of type report.
|
by: EnriqueM |
last post by:
One question: I created an access database that has been extremely
useful in my work. I dont' even know at what level of knowledge I am
at. I read a lot about how to create a database, created many tables,
connected them and then created different kinds of queries. (One thing
I have never done is reports, because I really don't need them)
I have many queries to track a particular job or aspect of it. i.e. I
sent on a particular item on a...
|
by: brucedodds |
last post by:
This post is for senior developers.
I'm an Access contractor. This morning I see a listing for a position
that seems to require development of a self-modifying database. The
application may need to provide an interface for the user to add
fields and possibly tables on the fly, with automated form and report
modification and generation.
I have never done this. While I have worked on projects where this
might have been useful, it has...
|
by: Supa Hoopsa |
last post by:
I am in the process of rewriting an MS Access application (access front end with SQL 2k database) in VB.NET and one of the things I would like to do is link in to the compiled Access ADE so that I can use the reports that have already been created. I have somewhere in the region of 200 reports already created in MS Access and I really don't want to have to create new ones.
I have successfully linked to the Access ADP, but would really like to...
| |
by: Edgar |
last post by:
Hi,
I need some advise on how to automate record selection on a stored
proc. Here is my situation. I have a stored proc that I used on
Crystal reports with two parameters - Acctcode and Subacct. When a
user enters ' *' on these parameter, it means to report on all
accounts otherwise, report only on specific account.
Here is my select statement with line numbers:
|
by: Liam.M |
last post by:
HEY GUYS,
need some urgent help here....I am querying my database based on a
DueDate field...and want to send an automated email to anyone that
falls within two months PRIOR to this "DueDate", so far the Code is
querying the database and trying to run a module I created, title
SendMail, however it is having trouble sending the email for some
reason... any suggestions as to why....here is the code:
|
by: sportygeek3 |
last post by:
Hi All,
I am looking for a way to automate other applications
programatically. Is there any C# library that will allow me to do
this?
i.e. I want to be able to iterate the menu items on another
application and send a mouse click to each one.
Thanks,
|
by: nandishp |
last post by:
We need to automate download of Reports from Oracle CRM OnDemand. The reports in Siebel CRM OnDemand can be downloaded in the form of Excel, CSV, etc. We have a task of downloading several such reports in Excel format everyday. The requirement is to automate the download of Reports by providing the URL of Excel format of report, Username and Password to logon to Oracle OnDemand.
Using CSHttpUnit, we could logon to the OnDemand instance...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |