topic Re: PHP to send mass email from spreadsheet? in Archive

PHP to send mass email from spreadsheet?

orthohin — Mon, 11 Feb 2013 19:05:17 GMT

Hi,

I am helping a colleague run for president of our association. I built the website now he needs to send an email to all the members ~15,000 people.

We were given a spreadsheet with first name, last name, and email columns. I would like to be able to send an email to each of the addresses. Ideally, It would also insert their name in the body of the email. Is there a service or program I can use to do this?

My host lets me send 750 emails/hour so I would like it to automatically do this as well. My colleague is willing to pay, but the more economical the better.

Thanks

Re: PHP to send mass email from spreadsheet?

Sogo7 — Mon, 18 Feb 2013 06:56:20 GMT

1. put the spreadsheet into a database

2. setup a cronjob running at 15 min intervals to query the databse + send mail

3. query the database -> get 180 email addresses at a time -> send them*

4. query the database -> remove the addresses you just mailed

Will take a little over twenty hours using a single email account,

if the host supports SMTP then the mail could be spread through mutiple accounts with other providers to speed up the process.

Do check with your host before sending a mailshot like this they could suspended your domain for spamming.