Thread: Mass mail sent only to 62 of 207 members

In Dolphin 6.0.2 I sent a mass e-mail and thought it would go to all 207 members but it only went to 62 of them.

Two questions:

1) How do I get it to go to all active members!??

2) How do I find out which 62 got the message so I can manually send it to the rest?

Thank you.

some people dont want your emails and you cannot force it

I removed the "opt out of receiving e-mails" checkbox from the join form so that all of them are supposed to get e-mails unless they send us an unsubscribe message.

ok either you manually go and change them all as admin to notify
or go into your database and change every `EmailNotify` to `Notify` in "Profiles"
there may be an sql query to run for that but i have no idea what it is ..so it should be quicker to do it manually

Thank you very much! By "manually notify," I assume you mean to check each checkbox and paste the message into the text field at the bottom and click Send Message. I tested it on myself and the html layout suffered a bit, but hey, it works! Thanks again!

To see how many users /who are set to NotNotifyMe, you can run this SQL query

Code:

SELECT NickName FROM Profiles WHERE `EmailNotify` = 'NotNotifyMe'

You could run this SQL query to change everyone to NotifyMe

Code:

Update Profiles SET `EmailNotify` = 'NotifyMe'

or

change in periodic/notifies.php

Code:

$res_eml = db_res("SELECT `ID` FROM `Profiles` WHERE `Status` <> 'Unconfirmed' AND `EmailNotify` = 'NotifyMe' $sex_filter_sql $age_filter_sql $country_filter_sql");

to

Code:

$res_eml = db_res("SELECT `ID` FROM `Profiles` WHERE `Status` <> 'Unconfirmed' $sex_filter_sql $age_filter_sql $country_filter_sql");

but note - there is a sex, age and country filter that could also affect how many emails get sent out.

Thanks Smoge! We'll do it.

Do you have any idea how they would have been set to "not notify" if I removed the option from the Join Form in the first place?

I'm thinking it might be because they didn't confirm e-mails in the normal way. A lot of them got stuck in moderation (confirm messages went to spam or whatever) so I just clicked the Activate button in the Admin panel to activate their profiles. Does the fact that they never confirmed an e-mail address affect this? It's the only reason I can think of for the problem.

Thanks again.

The "messages to spam / junk box / no place" is becoming a big problem. We are working on this with several ModMySite customers and have a couple of different ways to get around the problem.

One of them is a mod for Dolphin to use an SMTP server instead of localhost (php mail() function) when sending mails.

Smoge