select distinct email
from subaccounts inner join masteraccounts on
subaccounts.customerid=masteraccounts.customerid
where DatePart(dy,maExpireDate) >=
DatePart(dy,GETDATE()) + Extension
and DatePart(yy,maExpireDate) >=
DatePart(yy,GETDATE()) and datalength(s.email)>0
Regards,
Dan Tang
Network Operation
Domain Internet Access
---------------------------------------------------
Sign Up a Dial up account at http://isp.dmn.com.au and get connect right
now.
---------------------------------------------------
Join the Emerald ASP Addon Product mailing list
by sending email to emerald-request@dmn.com.au with message body SUBSCRIBE
only
-----Original Message-----
From: Kelly Wright <kelly@buz.net>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Friday, June 11, 1999 3:57 AM
Subject: [Emerald] Script to pull email listing
>I need a script to create a email listing for all our users. I want to
>email all our customers on some changes we want to inform them of. I have
>the fields populated in the Emerald for emailing invoices. How do I pull a
>listing of those emails with a script?
>
>Kelly Wright (kelly@buz.net)
>
>
>