On 9 Mar 00, at 15:31, Gregory Juster wrote: > DISTRIBUTE was on the next line and it was causing problems. > I was receiving the following error : > Job "CAMPAIGN" started on 3 Mar 2000 01:10:07 > > > DISTRIBUTE MAIL-MERGE DBMS=ODBC [log in to unmask] > Implicit DD (TO or DATA) not found in job stream. > > Job "CAMPAIGN" ended on 3 Mar 2000 01:10:07 Sounds like either the //TO DD line was malformed, or the SELECT statement did not return anything. Here is a sample job that works (assuming the database is set up and MYTABLE exists, and there is an email address starting with "FRANCOISE" in it): ------------------------------cut here---------------------------------------- //TEST JOB ACK=MAIL DISTRIBUTE MAIL DBMS=yes [log in to unmask] PW=xxxxx //TO DD * SELECT EMAIL FROM MYTABLE WHERE UEMAIL LIKE 'FRANCOISE%' /* //DATA DD *,EOF Date: &*date; From: [log in to unmask] To: &*to; Subject: Hi Hello, This is a test message. Francoise ------------------------------cut here---------------------------------------- Make sure that lines are separated by carriage-return-line-feed and not wrapping. Perhaps the mail program you are using is only using one or the other but not both. What mail program are you using to send the distribute job? What database software are you using? What is a sample output if you send the query you are using directly to the database? How is the database configured in your site.cfg file? Francoise