How to send a notification email to all members?

dudemail

Network license
License owner
Joined
Feb 16, 2015
Messages
24
Likes
2
Points
53
#1
Hi guys, do you know of a way we can send a mass email/notification message to all the members?
 

dudemail

Network license
License owner
Joined
Feb 16, 2015
Messages
24
Likes
2
Points
53
#3
Thanks. What's the way to download their email addresses?
 

Rodolfo

Chevereto Developer
Chevereto Staff
Joined
Oct 7, 2008
Messages
16,262
Likes
4,226
Points
237
Location
Chevereto HQ
Website
rodolfoberrios.com
#4
SQL:
SELECT
    user_email AS email
FROM
    chv_users
WHERE
    user_status = "valid"
AND user_email IS NOT NULL
AND user_newsletter_subscribe = 1;