Not working. I tried with only the email field, email, firstname, lastname. Result : not working. I also tried with a hardcoded list only with my email like so : //TO DD * [log in to unmask] Gregory Juster /* This should work, no? It doesn't! I tried again putting the distribute keyword on a different line and I'm still having the error : Job "CAMPAIGN-001" started on 10 Mar 2000 12:41:13 > DISTRIBUTE MAIL-MERGE DBMS=ODBC [log in to unmask] Error X'0100003B' loading recipient data from DBMS. Serious error occurred - traceback follows ------------------------------------------ >>> Error X'0100003B' loading DISTRIBUTE recipients <<< -> Severity: Error -> Facility: DBMS interface -> Abstract: SQL error Job "CAMPAIGN-001" ended on 10 Mar 2000 12:41:13 Anyway, here's the symplified job revised and still not working. The query should return 2 records. : //CAMPAIGN-001 JOB ECHO=YES DISTRIBUTE MAIL-MERGE DBMS=ODBC [log in to unmask] PW=342542 //TO DD * SELECT custem, tempfn, tempsn FROM itcust WHERE itcust.custno = itcuin.custno AND custem in ([log in to unmask],[log in to unmask]) /* //DATA DD * Date: &*DATE; From: Intertops Campaign ([log in to unmask]) Subject: My Subject To: &*TO; My Message /* -----Original Message----- From: LISTSERV list owners' forum [mailto:[log in to unmask]]On Behalf Of Ben Parker Sent: Thursday, March 09, 2000 6:44 PM To: [log in to unmask] Subject: Re: Implicit DD (TO or DATA) not found in job stream. ??? On Thu, 2 Mar 2000 11:11:39 -0500, Grégory Juster <[log in to unmask]> wrote: >//TO DD * >SELECT CUSTEM, TEMPSN, TEMPFN, CURTYP FROM itcust WHERE custem in >([log in to unmask],[log in to unmask]) >/* Does this SELECT statement work when submitted manually from a command line directly to the database?