473,785 Members | 2,575 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Automating email reports

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

Jan 24 '07 #1
7 1685
Rik
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. *
Jan 24 '07 #2
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
=============== ===
Jan 24 '07 #3
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/>
Jan 24 '07 #4
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.
Jan 24 '07 #5
Rik
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. *
Jan 24 '07 #6
Thank you all so much.

OP

Jan 25 '07 #7
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" />

Jan 29 '07 #8

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

Similar topics

7
12858
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.
7
2630
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.
1
2053
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...
2
1396
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...
4
3232
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...
6
1308
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:
1
2375
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:
3
2524
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,
2
2639
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...
0
9645
marktang
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...
0
9480
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,...
0
10148
jinu1996
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...
1
10091
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,...
0
9950
tracyyun
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...
1
7499
isladogs
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...
0
5381
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...
1
4053
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
2
3646
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.