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

I tried a lot of things and putting DISTRIBUTE on the same line then the job
name worked. Well, the error was gone but now I'm having a job start and job
end mail but nothing is sent out.

The log file say no more then start and end...

The query do return something normally and odbc setting are correct.

Anyway, I'm reinstalling everything on a new server. We'll see if it's
working.


-----Original Message-----
From: LISTSERV list owners' forum
[mailto:[log in to unmask]]On Behalf Of Francoise Becker
Sent: Thursday, March 09, 2000 1:50 PM
To: [log in to unmask]
Subject: Re: What I'm I doing wrong?


On 6 Mar 00, at 10:18, Grégory Juster wrote:

>
> I fixed my last problem. The distribute word needed to be on the same line
> then the job name like in following :
> //CAMPAIGN-001 JOB ECHO=YES DISTRIBUTE MAIL-MERGE DBMS=ODBC
> [log in to unmask] PW=1234567

This is not correct. DISTRIBUTE should be the start of a separate
line.


>
> Now, the job is "working" but no mail are sent. The echo return me :
> Job "CAMPAIGN-001" started on 6 Mar 2000 10:00:29
>
> Job "CAMPAIGN-001" ended   on 6 Mar 2000 10:00:29

What does the LISTSERV log file say?


>
> But no mail are sent. Like it couldn't find any recipient based on the
> query I made....but's everything is working with the wa.exe mail-merge
> and the query is ok.

If you send that query exactly as is directly to the database, do
you get any hits? Does itcust.custno really contain valid email
addresses?

Francoise