export emailing address

[jhansle1]

Hi all,

I was wondering if there is functionality to export all members email address (& names/logins) via the administrative control panel?

I want to do this so if my website is ever "crashed" and I can't access the ACP to mass email my members to notify them of the situation then I can send an email manually since I have their emails.

Thanks

[Dog Cow]

Yes, if you use a tool called phpMyAdmin, you can export that data in CSV and other useful formats.

[stevemaury]

To amplify, you cannot do it through the ACP, but in phpMyAdmin, run this and export the output as CSV (or Excel if you prefer):

Code: Select all

SELECT `username`, `user_email` FROM phpbb_users WHERE `user_type` != 2;