Skip to main content

Merge E-list Member Lists (Lyris)

You can combine the membership of multiple lists into one single list.

This article applies to: E-lists (Lyris)

  1. Download the list of members from each of the lists to be merged, one at a time, as described on our Export a List of Members page.
  2. Open the .cvs files in Excel.
    You may not see your file listed until you change the files being viewed to All Files or Text Files.
  3. Combine the member information into one spreadsheet.
  4. Remove anyone in the file who is listed as "unsub" or "unsubscribed" in the MEMBERTYPE_ column.
  5. Delete all columns except FULLNAME_ and EMAILADDR_.
  6. Save your data as a CSV file, not as a spreadsheet. This is important.
  7. Import the list of members as described on our Import a List of Members page.

Was this page helpful?

Your feedback helps improve the site.