The following SQL statement will return all current customers' email
address.
select distinct email from subaccounts s,masteraccounts
where s.CustomerID=m.CustomerID
and DateAdd(dd, m.extension, m.maExpireDate) >= GETDATE()
and (DataLength(s.saExpireDate)=NULL or DateAdd(dd, s.extension,
s.saExpireDate) >= GETDATE() )
-----Original Message-----
From: Kelly Wright <kelly@buz.net>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Tuesday, 23 March 1999 7:25
Subject: [Emerald] Email
>I need a script to pull all the email addresses from our db. Anyone know
>the commands to do so? I am trying to email all our customers.
>
>Kelly Wright (kelly@buz.net)
>BuzNet Communications, Inc.
>972-644-0440
>http://www.buz.net
>
>
>For more information about this list, including removal,
>please see http://www.iea-software.com/maillist.html
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html