Help – Website Support – Admins – How to Export all of the Members' Email Addresses

How do I export all of the members’ email addresses

  • How do I export all of the member’s email addresses?
    • Login to the WordPress Admin Site for BOL.  OR go to the MembershipWorks website directly at https://membershipworks.com/admin/#myaccount 
    • If on the BOL Admin Site, on the top left side, click on Membership Works
    • Enter your Membership Works login information, which is different than your other login information
    • On the left side, click on Members
    • Click on Export
    • Select all 5 email fields that all appear together: emailaddress1, emailaddress2, etc….
    • Do not click the Email field that is near the top as the 4th one down.
    • If you are exporting in order to import into MailChimp, also select the Name field (3rd from the top)
    • Click on Download
    • Click on the Excel file that opens on the bottom left
    • Expand, and Highlight all columns
    • Click Data/Sort
    • Click My data has headers
    • In the sorting tool, Enter all columns backyards, like this:
    • Click OK
    • Delete the top header row
    • Delete the two Admin rows that have NULL email addresses
    • Manually combine all columns together, starting from the right and going left. The result should be one column of emails.  If exporting in order to import into MailChimp, also copy the name field to all 5 columns.
    • If sending a direct email, Copy all of those into a new email, making sure to put them in the BCC area, not the To area.
    • Write your email, and send it

TO IMPORT INTO MAILCHIMP:

  • You should have a CSV worksheet with two columns, one for Name, and one for Email.  Remove all duplicates by highlighting both columns and clicking Data/Remove Duplicates.
  • Add column headers Name and Email
  • Login to MailChimp
  • Click on Audience/Audience Dashboard
  • Click on Manage Audience
  • Click on Import Contacts
  • Click CSV, then click Continue
  • Upload the CSV file, then click Continue to Match
  • Make sure Name is matched to Name, and Email is matched to Email Address
  • Click Continue to Organize
  • Click Add Contacts to Groups = News Feed Posts Subscription
  • Make sure Choose Status of these contacts = Subscribed
  • DO NOT Click Update existing contacts, because that will subscribe people who might have already unsubscribed on MailChimp.
  • (If you need to update someone’s name, do it manually in MailChimp, although we don’t use that field for anything.)