I have been trying to do a mail merge using the distribute command and have been receiving: > DISTRIBUTE MAIL-MERGE ACK=MAIL DBMS=YES Distribution aborted - no valid recipient. These are the error messages from the log: 11 Apr 2001 13:48:56 Processing file 140764 from [log in to unmask] 11 Apr 2001 13:48:56 From [log in to unmask]: DISTRIBUTE MAIL-MERGE ACK=MAIL DBMS=YES PW=abcdefg 11 Apr 2001 13:48:56 Executing SQL statements: > SELECT NAME, EMAILADDR > FROM MYTABLE > WHERE NAME LIKE 'PETER%'; 11 Apr 2001 13:49:00 Fetching... 11 Apr 2001 13:49:00 Recipient data extracted. 11 Apr 2001 13:49:00 To [log in to unmask]: Distribution aborted - no valid recipient. This is what I tried: //MYTEST JOB ECHO=YES // DISTRIBUTE MAIL-MERGE ACK=MAIL DBMS=YES , PW=abcdefg //TO DD * SELECT NAME, EMAILADDR FROM MYTABLE WHERE NAME LIKE 'PETER%'; /* //DATA DD * Date: &*Date; From: [log in to unmask] Subject: Monthly Newsletter To: &*To; Hello. This is the message. /* My DBMS-related parameters are defined as such: DBMS_DEFAULT_EMAIL=EMAILADDR DBMS_DEFAULT_TABLE=MYTABLE ODBC_DSN=MYDBNAME DBMS_DEFAULT_INTERFACE=ODBC Does anyone know why I'm receiving this error? I am sure there should be a couple of records from this query and they have valid email addresses in the field called "EMAILADDR". The first column in the table is the record id which is also the email address. I am using SQL Server, running on NT. What am I doing wrong or what am I missing?! Thank you, in advance, for any help. -KP