Re: [Emerald] generating letter for new users

Dale E. Reed Jr. ( (no email) )
Thu, 07 Oct 1999 20:34:58 -0700

Drew Philip Halevy wrote:
> Hi-
> The new user strikes again-we want to send an e-mail to each new user who
> signs up for our service-is there a way, command, etc that we can use to
> send this automatically (we are still using NTMail v. 3 and Emerald
> 2.5.278 -thanks-Drew

There is a new flag for each user that EmerAuth doesn't use. Create a
proc like this:

Select distinct cmd = 'blat newuser.txt -t ' +
CASE WHEN EMAIL is not NULL then Email ELSE Login + '@' + d.MailDomain
' -s "Welcome to my ISP" -f "" -s'