I am developing a “Parenting” website and I’m tasked with creating or finding a custom newsletter script, which I need help with.
Here are the specs…
I have 40 Articles, written for each week that a woman is expecting a baby. I need to allow women to sign up to receive these newsletters.
It sounds simple enough but here is where I’m stuck…
I need to be able to capture how many weeks pregnant somebody is when they sign up to the newsletters and ONLY send them the newsletter relevant to them. So if somebody who is 6 weeks pregnant signs up, they need to start receiving their weekly newsletters from “week 6” as there is no need for them to receive the first 5.
The articles are all pre-written and stored in a MySQL database with relevant ID’s… eg, Week 1 will be email ID 1, Week 40 will be email id 40 (this will be the one that stops the cycle.) So basically, I want a PHP Script that will do the following:
- Form input to capture personal details (name, email address)
- Form input - How many weeks pregnant are you now?
- Send their first email immediately after subscription for the week relevant to their answer to the above question.
- Continue to send the remaining emails, 1 each week until email ID #40 has been sent then stop.
Does anybody know how this can be achieved or whether there is a similar newsletter script out there that I can use to fulfil this purpose. I realise it’s not exactly a straight forward newsletter but any advice offered will be greatly received.