Bounces are not stored in the changelog table, AUTO-DELETES are stored in the changelog table. If you're runing an adhoc list distribution (based on a non-Listserv table) as oppose to a distribution to a Listserv maintained list (an actual Listserv list), you cannot re-direct bounces to a table. You must (if you need to somehow capture the bounces from a given distribute job) write the bounces to a file and/or send to an email account. If the list you're planing on distributing to is a Listserv maintained list, you should be able to re-direct the bounces back to the list and let the AUTO-DELETE list keyword handle the deletes. example of how to redirect back to LISTSERV list: //LISTNAME_MAILING JOB ECHO= YES // DISTRIBUTE MAIL-MERGE DBMS=LIST(LISTNAME) PW=xxxxxx , [log in to unmask] //TO DD "1=1" //DATA DD * Date: &*DATE; Message-Id: <LISTSERV%2006215134943@yourdomain> From: "Physics Today" <user@yourdomain> Reply-to: user@yourdomain Errors-to: user@yourdomain Subject: Editorial Preview April 2006 To: &*TO; MIME-Version: 1.0 Content-Type: multipart/Alternative; boundary="----_=_NextPart_000_01C26BAB.2FEB88E0" This is a multi-part message in MIME format. ------_=_NextPart_000_01C26BAB.2FEB88E0 Content-Type: text/plain; charset="iso-8859-1" example of how to configure AUTO-DELETE to delete on the first occurance of a bounce: Auto-Delete= Yes,Full-Auto,MAX(1),DELAY(0) ----- Original Message ----- From: "Francoise Becker" <[log in to unmask]> To: <[log in to unmask]> Sent: Monday, March 20, 2006 4:53 PM Subject: Re: Bounced Email > On 20 Mar 2006 at 16:07, Bruno Robichaud wrote: > > > Well the way we use Listserv is with a mail-merge DBMS backend, so the email > > list come from a DB table and I want the bounced to be in a DB table also so > > I can clean my email list table from bounced Email. > > Please take a look at the CHANGELOG_DBMS site variable and associated > variables. > > http://www.lsoft.com/manuals/1.8e/sitemgr/sitevars.html#cChangelogdbms > > You can have your cake and eat it too. You can let LISTSERV do the > bounce processing AND have the bounce information go to your > database. > > > -- > Francoise Becker <[log in to unmask]> > > Knowledge is just a click away: http://www.lsoft.com/optin.html