REGISTER or LOGIN to have the annoying ads removed.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How could i collect all members emails?
#1
Hello,
i want to collect all my user's emails so i can mass mail them (not using mybb's default mass mailer) so how could i collect them so i can email them?
Hopefully it's possible.
Reply
#2
custom export from phpmyadmin
Reply
#3
Ok thanks
If anyone doesn't know how then goto phpmyadmin then run SQL
Code:
SELECT email
FROM mybb_users
WHERE email <> ''
ORDER BY regdate ASC
Then export...
Reply
#4
Thanks for the tip,it's very useful.
[Image: neo.png]

[Image: userbar.php?uid=1]


Reply
#5
(Apr 04, 2010, 03:58 PM)neowarf Wrote: Thanks for the tip,it's very useful.

That signature is WAY too big.
[Image: mybbsig.php]
Reply
#6
sorry for a basic question however how can we set a query for both

SELECT email
FROM mybb_users
WHERE email <> ''
ORDER BY regdate ASC

AND

SELECT username
FROM mybb_users
WHERE email <> ''
ORDER BY regdate ASC

This is so that you get the users username as well as their respective email address.. Thanks for your help.
Reply
#7
Isn't much faster to just use MyBB's mass emailer?


If you wanted to use a different email address, you could have just switched yours in the default email.
Reply
#8
This is for sending out messages/ newsletters to your community. I have found the mybb options to be pretty pitiful. I love mailchimp and constant contact and have been experimenting with these systems to maybe switch to.

(Apr 14, 2010, 10:54 PM)User001 Wrote: Isn't much faster to just use MyBB's mass emailer?


If you wanted to use a different email address, you could have just switched yours in the default email.
Reply
#9
(Apr 14, 2010, 11:09 PM)underdogmike Wrote: This is for sending out messages/ newsletters to your community. I have found the mybb options to be pretty pitiful. I love mailchimp and constant contact and have been experimenting with these systems to maybe switch to.

(Apr 14, 2010, 10:54 PM)User001 Wrote: Isn't much faster to just use MyBB's mass emailer?


If you wanted to use a different email address, you could have just switched yours in the default email.


Good point. I prefer sending mass PMs for updates and mass EMAILS for site news.
Reply
#10
How do we output users and email for that respective user instead of doing it as two separate queries?

I would like to create a csv output of usernames and emails.

Thanks
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  Emails sent from MyBB are going to spam. Help? Ampix0 7 3,831 Nov 06, 2016, 10:36 AM
Last Post: Devin8890
Exclamation Block Proxies for Guests but not Registered Members Dilma 0 1,036 Nov 01, 2015, 12:10 PM
Last Post: Dilma
  Warning level for upgraded members? SeriesForum 1 983 Apr 11, 2014, 10:57 AM
Last Post: Ace700
  Prune members plugin don't work with 1.6 Glas 8 2,692 Sep 30, 2012, 11:19 PM
Last Post: liviuz
  How to send email or pm to all members? sudarsan7532 7 3,012 May 19, 2011, 11:55 AM
Last Post: Oliver Evans

Forum Jump:


Users browsing this thread: 1 Guest(s)