Email List on Forum

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Anti-Spam Guide
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Locked
pondrocket
Registered User
Posts: 81
Joined: Sat Jan 02, 2016 1:24 am
Location: Michigan
Contact:

Email List on Forum

Post by pondrocket » Thu Jun 28, 2018 12:26 am

Is there a way to get a list of all users emails on my forum and copy to an excel spreadsheet?

Pondrocket

User avatar
</Solidjeuh>
Registered User
Posts: 1547
Joined: Tue Mar 29, 2016 3:45 am
Location: Aalst (Belgium)
Name: Andy Dm
Contact:

Re: Email List on Forum

Post by </Solidjeuh> » Thu Jun 28, 2018 12:34 am

Register a free account & Play!!
~~~ https://www.solidjeuh.be ~~~
Have a secret? --> https://www.tellyoursecrets.eu

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50413
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Email List on Forum

Post by stevemaury » Thu Jun 28, 2018 12:37 am

Another way is to run this query and then export its output as CSV, or Excel:

Code: Select all

SELECT username, user_email WHERE user_type <> 2
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

Locked

Return to “[3.1.x] Support Forum”