How to export email addresses of all users

  • I want to export all email addresses of all users on my WordPress multisite, there are more than 3000 users/bloggers, I want to send nice html emails using external email marketing softwares.

    Can someone help me do it? is it possible to do it via phpmyadmin? or is there any plugin to do it?

    I used mailchimp plugin by wpmudev but it does not sync my current users.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Fair notice – If people did not OPT IN to those emails, then you will be spamming them. So keep that in mind.

    Try https://www.ads-software.com/extend/plugins/export-users-to-csv/

    Thread Starter Jamshid

    (@jsaf)

    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.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Did you try it on the wp-admin/network users menu?

    Thread Starter Jamshid

    (@jsaf)

    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.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Well, you can always grab them from your database (everyone’s in wp_users)

    Thread Starter Jamshid

    (@jsaf)

    They are not in one single table, what command shall I use to extract all email addresses from all wp_users at once?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    They are not in one single table

    Yes they are.

    Everyone is on wp_users.

    Everyone. In the whole network.

    Thread Starter Jamshid

    (@jsaf)

    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.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    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.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘How to export email addresses of all users’ is closed to new replies.