LSTSRV-L Archives

LISTSERV Site Administrators' Forum

LSTSRV-L

Options: Use Monospaced Font
Show Text Part by Default
Condense Mail Headers

Topic: [<< First] [< Prev] [Next >] [Last >>]

Parts/Attachments: TEXT/PLAIN (17 lines)
Print Reply
Sender:
LISTSERV give-and-take forum <[log in to unmask]>
Date:
Wed, 27 Mar 2002 09:15:24 EST
Reply-To:
LISTSERV give-and-take forum <[log in to unmask]>
Content-Transfer-Encoding:
7BIT
Content-Type:
TEXT/PLAIN; charset=US-ASCII
Subject:
From:
"A. Harry Williams" <[log in to unmask]>
MIME-Version:
1.0
In-Reply-To:
Organization:
Marist College
Comments:
On Wed, 27 Mar 2002 08:19:32 -0500 Stan Horwitz said:
>On Wed, 27 Mar 2002, Tim Parker wrote:
>
>> Is it possible to do the following....my company does a lot of one time
>> mailings to our customers, I am creating special lists with just certain
>> people and have to keep running a QUIET DELETE for a list of people that
>> have asked for no mail from us (opt-outs).
>
>This sounds more like a database question than anything else. Set up an
>SQL database of your clients with a flag for each client's record to
>indicate their opt-in or opt-out preference. Once a night, you could run a
>simple script to build the lists from scratch to quietly subscribe each
>opt in client to the appropriate list.

Actually, if you set it up as a DBMS system , you should be able to
create a VIEW that does all this work for you.

ATOM RSS1 RSS2