I have read through the Developer's guide several times and am still not sure of a couple of things. What we want to do is create several Distribution lists which will pull information from a SQL 7 database. As an example we want to create a list called: [log in to unmask] which will contain all employees whose EmpType is 'faculty'. We want to create about 30 lists with different criteria each with it's own email address. My question is what is the best way to do this? Should we create separate Views in SQL to act as tables? Another question is what is the correct syntax for addressing tables on the SQL Server? My current DBMS statement: DBMS=Yes,TABLE(ifasdir.Employee),EMAIL(IFASEmail),NAME(LName) Generates these errors when trying to review the list membership: Serious error occurred - traceback follows ------------------------------------------ >>> Error X'01000023' reading DBMS list <<< -> Severity: Error -> Facility: DBMS interface -> Abstract: No such table >>> Error X'01000023' reading DBMS list <<< -> Severity: Error -> Facility: DBMS interface -> Abstract: No such table Thank you in advance, ___________________________ Mike Kanofsky Systems Programmer IFAS Information Technologies University of Florida (352) 392-5180) _____________________________ SQL server name is: INFO Database on SQL server is: IFASDIR Table in IFASDIR is Employee ListServ server is: LIST I created a SystemDSN on LIST labled Email-DATABASE. In SITE.CFG I added: ODBC_DSN=Email-DATABASE ODBC_UID=user ODBC_AUTH=pass DBMS_DEFAULT_EMAIL=IFASEmail DBMS_DEFAULT_NAME=LName DBMS_DEFAULT_TABLE=Employee List Header: === IFAS Database Integration Test List Subscription= By_owner Ack= Yes Confidential= Service Validate= No Reply-to= List,Respect Review= Owners Send= Private Errors-To= Owner Owner= [log in to unmask] Notebook= No DBMS=Yes,TABLE(ifasdir.Employee),EMAIL(IFASEmail),NAME(LName) ===