Fair notice – If people did not OPT IN to those emails, then you will be spamming them. So keep that in mind.
Try http://wordpress.org/extend/plugins/export-users-to-csv/
this will only export users for a single blog, I am the administrator of a wordpress multisite, I want to export the users for all blogs on my entire network.
Did you try it on the wp-admin/network users menu?
It does not appear on wp-admin/network users menu. I installed the plugin and then network activated it.
It only shows in users menu of every single blog.
Well, you can always grab them from your database (everyone’s in wp_users)
They are not in one single table, what command shall I use to extract all email addresses from all wp_users at once?
They are not in one single table
Yes they are.
Everyone is on wp_users.
Everyone. In the whole network.
Yes they are.
Everyone is on wp_users.
Everyone. In the whole network.
They are not in a single table, I have more than 30000 tables in my database. Every blog has its own set of individual tables.
And how many wp_users
tables do you have?
Unless you have multiple separate installs of WordPress, a Multisite install has only one table named wp_users
.
Now, if you have 300000 users, you will have 300000 LINES in your table, but you have but one table.
You have 3000 users. They are all listed in wp_users
, or you did something terribly wrong with your multisite.