Jump to content

A way to send Client Details Reminder to ALL Clients?


Recommended Posts

Be aware that depending on how many clients you have, it may not work. There is a bug that is supposed to be resolved in the upcoming 3.6.0 which will prevent mass mailing from working with a large list of recipients in some cases. (It has to do with a bug in certain versions of PHP with handling a large POST payload, so Matt reworked mass emailing to not pass the recipient list via a POST.)


You will know whether or not the bug will affect you if you follow JRawly's suggestion but don't see anything in the editor after attempting to load a saved message.


I had to let customers know their login information after conversion from AWBS, but WHMCS couldn't do it because of the size of our customer base. I ended up writing a quick and dirty script to generate a list of names, email addresses and passwords, and then sent the mailing through another system.


The below script code just spits out the data to your browser, and I copied and pasted the output to a text file and imported it into a newsletter marketing system we use:




       $db = mysql_connect("localhost", "username", "password");

       $query_string = "select * from tblclients where status = 'Active'";
       $query = mysql_query($query_string);
       while ($row = mysql_fetch_assoc($query)) {
               echo "\"".$row['email']."\",\"".$row['firstname']."\",\"".$row['lastname']."\",\"".decrypt($row['password'])."\"<br>";



(Change username, password and dbname in the mysql_connect and mysql_select_db calls.)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated