Re: [Emerald] Script to pull email listing

Dan Tang ( (no email) )
Fri, 11 Jun 1999 22:04:24 +0800

Depend how you use your Emerald. Easy one is

select distinct email
from subaccounts inner join masteraccounts on
where DatePart(dy,maExpireDate) >=
DatePart(dy,GETDATE()) + Extension
and DatePart(yy,maExpireDate) >=
DatePart(yy,GETDATE()) and datalength(>0


Dan Tang
Network Operation
Domain Internet Access
Sign Up a Dial up account at and get connect right
Join the Emerald ASP Addon Product mailing list
by sending email to with message body SUBSCRIBE

-----Original Message-----
From: Kelly Wright <>
To: <>
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 (