How to export email from chevereto?

[anurajrv]

I need to export email id's of my users for sending bulk emails. How can i do it?

 

[Rodolfo]

Run a MySQL query:

SELECT user_email FROM chv_users WHERE user_email IS NOT NULL AND user_newsletter_subscribe = 1;

That will get you all the emails.

Cheers,
Rodolfo.

 

[Focker]

We can't email directly from our admin dashboard correct? We have to use an external email service?

 

[Rodolfo]

We can't email directly from our admin dashboard correct? We have to use an external email service?

External.

 

[Focker]

One more question about this just for my knowledge.

In the user setting there is -
Newsletter
Send me emails with news about websitename.

How does this work then?

 

[Rodolfo]

That allows you to detect which users want to get your newsletter. You don't want to send emails to everybody, your complain rate could be huge.

 

[Focker]

You don't want to send emails to everybody

True.