Hi,

Is it possible to execute a store procedure for a mail-merge with listserv?

I tried exec, execute or just putting the SP name but nothing's work!

Thanks....

Here's what I do :

//campaign222 JOB
DISTRIBUTE MAIL-MERGE DBMS=ODBC [log in to unmask] PW=aaaaaaaa
//TO DD *
SELECT CUSTEM,TEMPSN,CURTYP FROM itcust
WHERE context = 'cs'
/*
//DATA DD *
Date: &*DATE;
From: Campaign
Subject: Campaign
To: &*TO;

Hey there &TEMPSN;!

Your currency type is &CURTYP;!

...
/*

Grégory Juster
NOMEX Inc.
460, rue Sainte-Catherine Ouest, bureau 200
Montréal (QC)  H3B 1A7
courriel : [log in to unmask]
http://www.nomex.net