How to send message to all members?

We have a problem.

We need to send an email (ideally via mass mailer) to all our members - also to those who have chosen not to receive new letters.

Does any of you great people have a nice solution to this?

All the best

Finn

  • View
    553
  • More
Replies (2)

    • Hello Finn from EducatedSingles !

      Well, it's possible only if make all users refused to get newsletters as agreed to get those letters :-)

      It's possible to do with the following MySQL queries (backup the `sys_accounts` table first):

      UPDATE `sys_accounts` SET `changed` = 1 WHERE `receive_updates`=0;

      UPDATE `sys_accounts` SET `receive_updates`=1 WHERE `changed` = 1;

      Then make mass mailer performance.

      Then it will need to back the "opportunists":

      UPDATE `sys_accounts` SET `receive_updates`=0 WHERE `changed` = 1;

      UPDATE `sys_accounts` SET `changed` = `added`+3600 WHERE `receive_updates`=0;

      • Dear LeonidS 

        Thank you very much!

        All the best

        Finn

        Login or Join to comment.