Sending HTML emails online

lulubell

I'm relatively new to PHP and at the moment I'm drowning and desperately need some help...

I've built a database which contains contacts information. I want to be able to send a HTML email to specific entries (Such as those where country='United Kingdom' and where the opt_out='No')

I would like to be able to upload the HTML email to the server, select the specific entries, send them the email, and do some tracking such as how many people opened the email, who chose to opt out after it was sent, if the followed any links on the email and so on.

Does anyone know of anywhere I can see some code that does this, or can point me in the right direction of where to start.

I've tried reading variuos books on Building a Mailing List manager, but there is too much code that does not do what I want to achieve andthen I get lost in it all.

If someone could at least explain the stages that I need to follow that would be extremely useful

Cheers

Lulubell
😕

planetsim

Firstly you cannot check to see who opened the email unless you have sort of link that needs to be sent back to the site. Even that isnt accurate.

When sending the email, you'll need to create a query

which may look like this

"SELECT * FROM contacts WHERE country = '$country' AND opt_out = '$opt_out'"

Firstly with doing this id make a form which has information on who to send the mail to etc.

Then from there the query which i have, it may need to be changed.

From there id probably have all types of emails already on the server, ready to be just sent off when something is trigged. e.g. Email to UK, the email to all people in the UK is sent out etc.