[Posted to LSTSRV-L and LSTOWN-L.] Colleagues, I have a need to easily obtain all subscribers for all lists, without duplicated addresses (such as where a given subscriber is subscribed to two or more lists). The end result needs to be a single listing of email addresses and, optionally, corresponding names, without duplicates, representing all subscribers of all lists. Problem: With 150+ lists, it is inconvenient and time-consuming to issue the typical REVIEW command for each list, and then merge and purge to delete duplicates. Having read all the manuals and scanned the archives, and having posted this question some weeks ago, I am fairly well convinced that there is no ready means to accomplish this task. For example, for security reasons, as I recall, LISTSERV does not have a command to do what I want. I do plan to implement DBMS and utilize MS SQL 2000 Server as the datastore. Indeed, I have set up a test list that accomplishes this. However, given the demands on my time, it will likely be several weeks or months before I can migrate all existing lists to SQL 2000. At that point I will have a number of options for pulling data out of the database -- problem solved. Until then, though, I find myself spending considerable time getting the simple end-result I need: a single listing of subscriber email addresses for all lists, without duplicates. Anything I'm not considering? Is there some simple thing I'm missing? Steve Stephen C. Nill, J.D. Founder & Chief Executive Officer [log in to unmask] <http://charitychannel.com/>CharityChannel.com - The Conference That Never Sleeps (tm)