Total active user: 132,507
There are currently 131,004 unsent emails remaining in the mail queue. After Send Email to Users 8 hours :(

Very useful indeed. Thanks so much!

130,000+ emails is an insane amount to send, and will take an extremely long time unless you use some high settings.

I am a dumbass! I fixed my problem.

Thanks for this!

I just moved to a new hosting company and their limit was only 150 per hour, I got them to increase 750, but still way under my newsletter subscribers.

Will be testing it out today. Thanks again

UPDATED: tested and this hack works perfectly! All my subscribers got their newsletters and they're all happy.

after importing the product, where can i edit the settings ?
im not able to find them on my admin cp, should i edit the product file befor uploading it or what ?

What setting(s) are you referring to ?

Hello Paul,
Thanx for replying, please i need to know a few things:
1- where can i set the number of email sent per hr, is it only by puting the number in the e-mail settings or i need to put it in an other place.
2- how can i remove the e-mails from the queue
thank you

1. Please read the main (first) post, the settings are explained there.

2. You cant, unless you want to run direct sql on the relevant table.

Can anyone explain how to delete unsent emails, as I've sent to the wrong usergroup.