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
END +
' -s "Welcome to my ISP" -f "admin@isp.com" -s 1.2.3.4'