Everywhere else I use ODBC It's possible to execute a SP. Why has this been blocked in ListServ? For me this a serious problem and seems like a very unnecessary limitation which cripples the whole mail merge function. Anyway I haven't done a trace in my SQL Server but I get the msg "Distribution aborted - no valid recipient" which I read as if ListServ actually tries to run the query, or? Regards, Johan -----Ursprungligt meddelande----- Från: John Traweek [mailto:[log in to unmask]] Skickat: den 7 maj 2003 13:50 Till: [log in to unmask] Ämne: Re: mail merge using stored procedure fails I know for a fact that I run UPDATE statements all the time, so I know SELECT statements aren't the only T-SQL commands allowed, as for SP's I don't know, never tried it. John Traweek Senior Account Director Publishing Concepts, LP 12840 Hillcrest Rd, Ste 230 Dallas, TX 75230 Phone - 972.774.3280 Fax - 972.448.1622 -----Original Message----- From: Johan Kronberg (n3sport) [mailto:[log in to unmask]] Sent: Wednesday, May 07, 2003 2:34 AM To: [log in to unmask] Subject: SV: mail merge using stored procedure fails That is really lame! Why is it so? Mustn't there be a way around just SELECT? After all Stored Procedures is the proffesional way to work with a databaseapplication. Johan -----Ursprungligt meddelande----- Från: Francoise Becker [mailto:[log in to unmask]] Skickat: den 6 maj 2003 20:07 Till: [log in to unmask] Ämne: Re: mail merge using stored procedure fails On 6 May 2003, at 15:48, Johan Kronberg (n3sport) wrote: > How do I run a SQL Server Stored Procedure instead of a regular > SELECT-statement? You can't. Only SELECT statements are allowed. Francoise