WordPress.org

Ready to get started?Download WordPress

Forums

How to export email addresses of all users (10 posts)

  1. Jamshid
    Member
    Posted 2 years ago #

    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.

  2. 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/

  3. Jamshid
    Member
    Posted 2 years ago #

    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.

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

  5. Jamshid
    Member
    Posted 2 years ago #

    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.

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

  7. Jamshid
    Member
    Posted 2 years ago #

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

  8. They are not in one single table

    Yes they are.

    Everyone is on wp_users.

    Everyone. In the whole network.

  9. Jamshid
    Member
    Posted 2 years ago #

    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.

  10. 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.

Topic Closed

This topic has been closed to new replies.

About this Topic