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: 80
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: 953
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

Wij promoten UW muziek in ons forum & delen alles via Sociale media!
Muziek wordt ook toegevoegd in de playlist van
textradio.be!
Mail uw single + hoesje + info naar: info@muziekpromo.net of Solidjeuh@textradio.be
===============
Onze Website: https://www.muziekpromo.net

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 49465
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: Baidu [Spider], Bing [Bot] and 21 guests