[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)