A way to send Client Details Reminder to ALL Clients?

[eugenevdm]

Due to certain system changes we would like to send a Client Details Reminder to all of our clients. Does anyone know if this is possible?

[WHMCS Andrew]

Mass Email.

 

http://www.yourdomain.com/whmcs/admin/massmail.php

 

select the clients, then on the next step, choose to load a saved message, and load the client area details reminder (at the bottom of the page)

[Troy]

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:

 

<?php

       require("dbconnect.php");
       require("includes/functions.php");

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

       $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.)