Mass mail only domain without hosting

[Kelby]

Hello,

How to mass mail only users that has domain only?

Thanks

[brian!]

1 hour ago, Kelby said:

How to mass mail only users that has domain only?

I suspect you would have to create a client group of such users and then mass mail that client group.

to get such a list of domains with no hosting, you could use the SQL query in the thread below.

[Remitur]

You can:

• create a user custom field "newsletter" (hidden to the user)
• with a mysql quey, switch its value to TRUE for any active user who has not active services
• and the use the normal mass-mailing WHMCS tools,  using the custom field "newsletter" as filter

Note: I use such a custom field any time I need to send the same message to a group of users; if the number of users is low, you can also switch the value by hand, and it's a quick and dirty way to do it...

 

[brian!]

2 minutes ago, Remitur said:

Note: I use such a custom field any time I need to send the same message to a group of users; if the number of users is low, you can also switch the value by hand, and it's a quick and dirty way to do it...

which would actually be a better solution than using client groups as a client can only be assigned to one group, whereas using a specific custom field would be cleaner, and multiple fields could be used for multiple different posting purposes.

4 minutes ago, Remitur said:

with a mysql query, switch its value to TRUE for any active user who has not active services

are you setting the values to false before running the query ? otherwise a user who didn't have hosting previously (and was set to true), but later gets hosting (would still be true).