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