E-newsletter: need to keep track of subscriptions expiring

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.
http://www.tassietek.com/mailerfree/default.asp
or
http://www.tassietek.com/mailerpro/

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
LVL 3
danomaticAsked:
Who is Participating?
 
fritz_the_blankConnect With a Mentor Commented:
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.

FtB
0
 
JagCConnect With a Mentor Commented:
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:

DateAdd("M",12,now())

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 :)
0
 
MrClean21Commented:
Hi,

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())

MrClean
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
danomaticAuthor Commented:
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.
0
 
danomaticAuthor Commented:
I am sorry, I have gotten held up on this project, I will resume this week.
0
 
fritz_the_blankCommented:
0
 
fritz_the_blankCommented:
Glad to have helped, but any reason for the grade of B?

FtB
0
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.

All Courses

From novice to tech pro — start learning today.