|  | Ok, I'll bite on this one.
I work for Standards and Methods Control, and we have some tools we've built 
over the past 18 months to help us manage distribution lists.  We have 
somewhere around 1,000 unique distribution lists for our EL-class internal 
documents (DEC STDs, specs...).  Because maintaining lists are such a 
nightmare, we set things up so that these lists are maintained primarily by 
our customers who use our VTX SMC application.  
Customers using our VTX application can add themselves to any (non-restricted) 
list, delete themselves, change the quantity, update their employee 
information, request a list of documents they are registered to receive from 
SMC, choose to receive an electronic notification message when a document 
changes as opposed to receiving the hardcopy, and a bunch of other neat stuff.
We update (change employee information [e.g mailstop], delete employees 
from lists) our database weekly for U.S. employees with the feed from the 
Employee Master Personnel File.  Data for non-U.S. employees, unfortunately, 
is not easy to come by.
In addition to customer changes via VTX and the Personnel feed, we also 
have a menu-driven interface available here in SMC to create and maintain 
lists.
    			DISTRIBUTION LIST MENU
 01 - Employee Maintenance                 12 - Report of Distribution Lists
 02 - List Maintenance                     13 - Site Code Report
 03 - Site Code Maintenance                20 - Run Personnel Extract
 04 - Copy Employee Dist. List             90 - SMC Main Menu
 05 - Transfer Employee Dist. List         91 - SMC VTX
 06 - Sort SMEMAIL.RPT By Name             92 - SMC CDROM
 09 - DEC STD List Add/Delete              97 - VAX Mail
 10 - Copy Distribution List               98 - Exit to Monitor Mode
 11 - Merge Distribution Lists             99 - Sign Off From System
We had enhancements planned for our VTX interface to make the VTX user's job 
of updating their list information much easier than currently possible, but 
that's been pushed out as a cost avoidance measure within our group.  We'd 
be happy to discuss what we've done with any other internal group.  Maybe
we could work together to develop and provide a common interface for order 
processing (documents, forms, office supplies, whatever) and distribution 
list maintenance.
- Jim (287-3679)
 |