need some help please

[Jamesi]

I am trying to write a web based application for automated email marketing. What needs to happen is a client subscribes, day one he recieves email one, day two he gets email two, etc. This is happening while subscribers who came before him get the email corresponding to the day that they are on. I am using Access and ASP. Any thoughts?

Thanks in advance!

 

[MadMaxx]

What exaclty are you looking for? How to e-mail or how to set up your project?

 

[Jamesi]

email system

Thanks for responding. What I am stuck on is how to send out the proper emails to the correct clients automatically. Again for example, if I have 3 clients: client 1, client 2, client 3. Client 1 signs up today, 2 signed up yesterday, and 3 signed up 2 days ago, 1 should recieve the first email, 2 should recieve the second email, 3 should recieve the third email. I need to make the system automatic so everyday at 12 am the program will run the checks and each client recieves the email that corresponds to that day.

Thanks again for your help

 

[MadMaxx]

What about using dates.
create a recordset of all the users. Then compare todays date with the date they joined. Then use values to send out the correct e-mail. Just taking a stab at it. Haven't had to do this before. Also. Don't understand why you would want to do this in the first place. It will get complicated as time passes and more people subscribe. I would backlog any e-mails. I would just send them the latest. This also raises another issue. If user 1 joined 3 months ago and user2 joins today then the way your saying is that user2 will get the email user1 got 3 months ago. If it is a news letter and they are getting once a day then user2 will always be 3 months behind user1 in the news.

Maybe I'm just rambling but you should really think it over before doing it and really see if it applies to your application.

 

[Jamesi]

I tried using dates but the person I am building this for would have to log into the admin side of his web site once a day for the script to run, which he is too lazy to do. You did understand correctly, but it isn't really a newsletter. The site it is for is a 'pay to play games site', and the messages are all logged in the database for the person to recieve them in the specific order on specific days. I do have a email program that can do one time email blasts to all subscribers in a list but this was not what my client wanted. Hence the problem . Is it possible to design a front end application on my server that could log into his site in order for the script to run? Or is there a way to build an application that could do the emailing for me at a certain time? Any thoughts would be appreciated.