Comment to 'How to send message to all members?'
  • 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;

    💓0 😆0 😲0 😥0 😠0 0
    • Dear LeonidS 

      Thank you very much!


      All the best

      Finn

      💓0 😆0 😲0 😥0 😠0 0

    UNA - Network Infrastructure for Communities

    Close