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.