3 posts by 2 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: March 5, 2018   (RSS)

Hi All.

I'm wondering how I would go about sending an email (either via the newsletter module, or via an email template) to those members who have a certain favorite?

Cheers,

Tim Forrest
Toledoh Enterprises
www.toledoh.com.au

Thanks Dave. 

For anyone else that's trying a similar thing, this query works for me;

SELECT num, email
FROM cmsb_members
WHERE num IN (
SELECT createdByUserNum FROM cmsb__website_favorites WHERE recordNum = 7
)

So I've now created a "mailing list" via the newsletter plugin.

Cheers,

Tim Forrest
Toledoh Enterprises
www.toledoh.com.au