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.
Scam Warning
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: 1068
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

We offer fun HTML5 games for young and old.
Register a free account & enjoy all functions!
Save your score, challenge other members or play along with our tournaments.


~~~ https://www.solidjeuh.be ~~~

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 49628
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. PM or email me.

All unsolicited PMs will be ignored.

Locked

Return to “[3.1.x] Support Forum”

Who is online

Users browsing this forum: No registered users and 23 guests