MyBB Community Forums

Full Version: Export mail list
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi, I wanted to know if there exists the option to export the list of mails of the users registered in the forum. For example in a file CVS of outlook. I wanted to send information of the site to the users across other system of sending of mail Wink.

Regards!.
Can you run this SQL code in phpMyAdmin?
SELECT email FROM mybb_users
(Remember to replace any instance of mybb_ with your forum's database table prefix, if different)

If you're running one of the later versions of phpMyAdmin you will be able to click "Export" [attachment=6035]

Then select CSV [attachment=6036]

If you want the username with the email, you can use SQL query:
SELECT username,email FROM mybb_users
Thanks Dennis! Big Grin