Batch send implemented in Simplenews 4.6?

Unfortunately, not in 4.6. 4.7 has a cron throttle option though.

Hoping it may help someone.

We just installed simplenews for our monthly newsletter with over 1000 subscribees (up to now, we had been using mynewsletterbuilder.com). The February newsletter is due out today, but yesterday, I learned that our host limits us to 600 outgoing emails an hour. So, we needed an emergency measure so that our 1000 subscribees receive the newsletter this month. Next month, we'll probably be running Drupal 4.7.

So, here is how we did it: we manually manipulated the database.

Don't try this at home. If you do, make a backup of the database first. If you don't know what you are doing, don't try. Take your responsibilities.

We just imported the 1100 emails. All are set as active, by default. To send the newsletters in two batches, I will set the first half, then the second half as inactive.
UPDATE `drupal_sn_subscriptions` SET `a_status` = '0' WHERE `snid` <590

Then reset the newsletter as being unset (200 being the node number of the newsletter):

UPDATE `drupal_sn_newsletters` SET `s_status` = '0' WHERE `nid` =200 LIMIT 1 ;

Then reverse the status:

UPDATE `drupal_sn_subscriptions` SET `a_status` = '1' WHERE `snid` <590
UPDATE `drupal_sn_subscriptions` SET `a_status` = '0' WHERE `snid` >589

Set the newsletter as unsent:
UPDATE `drupal_sn_newsletters` SET `s_status` = '0' WHERE `nid` =200 LIMIT 1 ;

Send again one hour later, then set the status = 1 everywhere again.

UPDATE `drupal_sn_subscriptions` SET `a_status` = '1' 

If it can help someone, I'm happy.

==
http://www.reuniting.info/
http://www.wechange.org/