php - CodeIgniter Mailing loop -

i ask whether has tried send mails loop lets 1k rows. make mailing list , send mails in loop each email address in table. or there better solution ? thanks

external (like mailchimp) easy , better way go. if yourself, read on.

create table called 'mails_to_send', or whatever, email address, subject , body columns (and id , possible attachments, etc).

then create php script loops through x mails, sorted oldest first (id asc), x high number, not high won't hit php execution time limits. loop through x records, , send each mail (all necessary info in table).

if want regularly:

set cron job every y (every hour, or every 10 minutes, number amount of emails need send lower amount of emails can send way). forget it. can create admin function create newsletters, or whatever.