E-newsletter: need to keep track of subscriptions expiring

Posted on 2004-08-23
Medium Priority
Last Modified: 2009-12-16
I am looking to do the following with ASP.

We have a website where a person will be able to subscribe to a paid e-newsletter

These things are in place:

1) Subscribe to an e-newsletter – I have a pre-built solution which  I have not gotten to work yet but I believe it’s just a few mail server settings.

2) pay for newsletter
This is in place – we have an existing internet merchant account which goes to authorize.net and we are already able to make this work with taking secure payments from a web page form with ASP

3) This is where I need the help. How do you keep track of a persons subscription expiring -- 149.00 for 1 year -- and toward the end of the one year, generate an email to the person that the subscription is due for renewal.

The mailer free or mailer pro comes with a decent pre-built Access database.

-- Dan
Question by:danomatic
LVL 46

Accepted Solution

fritz_the_blank earned 900 total points
ID: 11872567
So what you need to start with is a SQL select that will give you the records that you need:

strSQL = "SELECT * FROM tblYourTable WHERE DateDiff('d',datYourDateField,Date())<45"

for example would give you all records that will expire in the next 45 days.


Assisted Solution

JagC earned 600 total points
ID: 11872944
Does the access database come with an expiry date field in the user table? If not then add one. You may need to modify your subscription pages to add an entry in this field.
Eg if they sign up for a year add the field as:


This would add 12 months to the current date.

If you want to send out a reminder (assuming it's not included with the news script) you need a function that will mail those that are going to run out soon. Without getting into scheduled scrpipting (covered loads of times on EE) I'd do the check when sending out the newsletter.
If the newsletter script already has an expiry check then great. (If not add it - see above).

When sending out hte newsletter, call a separate function which checks to see which accounts are going to run out (use FtBs sql statement).

Doing it as a function and calling it when the newsletter is sent means that a user will recieve the newsletter and a separate reminder email.

This all assumes though that this email program isn't wrapped up in a DLL or something :)

Expert Comment

ID: 11872959

You could use an expireDate field in the database and select * where expireDate > Date().
To email a notification, you could use a vbscript running in a scheduled task every night sending an email to everyone who has select * where expireDate = DateAdd('d', 7, Date())

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.


Author Comment

ID: 11873701
wow, ok I have to digest some of this.

Let me check on the script to see if there is any means of expring a subscription.  There are no DLL's invloved at all, just ASP and soem VBScript.

Author Comment

ID: 12098457
I am sorry, I have gotten held up on this project, I will resume this week.
LVL 46

Expert Comment

ID: 12327641
Glad to have helped, but any reason for the grade of B?


Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…

621 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