Documentation

Generating Member Reports

Last modified on September 18, 2026 by Christian Saborio

Overview

The system has the functionality of exporting member information into a Comma-Separated-File (CSV).

Microsoft Excel can easily open CSV files.

In this section we’ll walk through the options for generating reports containing information about the members.

Generating an Active Member Report

To send out journals and other information that requires snail mail, it is necessary to obtain the physical address of all active members. Let’s go ahead and generate this CSV file.

  1. To view all ESAANZ members, click Members under the MemberPress menu:

Let’s filter down the list to active members. From the All Members dropdown, select Active Members (1) and click the Go button (2):

  1. Scroll down at the bottom of the screen, you should see two links that read:
  • Export all as CSV (XXX records)
  • Export table as CSV (XXX records)
  1. Click on the option that reads Export all as CSV (XX records)

You may or may not be asked to confirm the file download (depends on your operating system and browser)

Open the file once it finishes download with Microsoft Excel or any spreadsheet application.

  1. You should see an Excel document that contains every bit of information about the active members.

This spreadsheet contains sensitive data, make sure to delete it after you finish working with it.

If you ever need a copy of the file, follow the steps above to obtain the most recent version.

We are interested in obtaining the physical address for each of the active members.

  1. Scroll horizontally until you find the column headers that reads mepr-address-one

You should see the physical address for each active member.

Using this information you can format the CSV file to auto-generate mailing envelopes to send mail.

You can use this reference as a guide on how to accomplish this: Use Microsoft Word To Create Envelopes For Your Contacts