Mass Mailer

Why do not all the members who agree to receive newsletters get place in the que?

For example:

Send to Members (89 members agree to receive newsletters)

But only 42 mails are placed in the que.

Weird. Any ideas?

X number of mails will be placed in the queue.  They are sent out and then x number of mails will be placed in the queue.  This repeats until all mails are sent out.  The idea is to not flood the mail server, especially if you are using a third party mail server such as with a shared host.

Thanks Geek. I get the feeling that the remainder of the emails to be added into the que are not being added on. I will monitor this next time to see the countdown.

 Check to see if everyone has the option checked in their profile to receive emails from the site.. the ones that weren't added most likely don't have it checked. They are all added to the queue at once but then the site only sends a set number out at a time.. so even if you have 5000 members if they all have that option checked then the queue would show 5000 after you click send. 

OK, I guess I told you wrong then if the above is how it works.  I don't use the mass mailer and was relying on memory of what I had read before.  OK, in this case what you should see is that the number in the queue decreasing as the mails are sent out.

My apologies for misinforming you earlier.

I checked the data base and all but a few have it checked. It the setting in the profiles table right?

 Yes, it's the email notify field in the profile table. The other thing to check is that everyone has a valid date of birth also. In the past people have removed that (or some of the other mandatory fields) and people weren't being added to the queue.

Oh that's interesting about the date of birth field. Does anyone know of a SQL script I can run to replace those empty date of birth fields with a standard birth date. Or is there another way to over ride this?

 Are the fields empty or are they "0000-00-00"? If they are 0000-00-00 you can try this:

 UPDATE`Profiles` SET`DateOfBirth`= replace(DateOfBirth,'0000-00-00', '1970-01-01')

Make sure you back up the database first..

Thank you. It was indeed the empty date of birth field that prevented people from entering the mass mailer que. Your sql script run worked a treat.

You're welcome, glad I could help.