Also, where do you put the new user test file that you want to be sent?
Is this a script that has to be run manually, or will it just send these=
letters automatically?
John
*********** REPLY SEPARATOR ***********
On 10/7/99, at 8:34 PM, Dale E. Reed Jr. wrote:
>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 =3D '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'
>From MasterAccounts ma, SubAccounts sa, Groups g, Domains d
>Where ma.CustomerID =3D sa.CustomerID
> and ma.GroupID =3D g.GroupID
> and g.DomainID =3D d.DomainID
> and sa.AccountType in ("PPP", "ISDN")
> and sanew <> 0
>
>Update SubAccounts
>Set sanew =3D 0
>Where AccountType in ("PPP", "ISDN")
>GO
>
>Then use an SQL7 bcp command in a batch file like:
>
>domilusers.cmd:
>
> bcp "EXEC Emerald..MailNewUsers" queryout mailnew.cmd -c -S server -U
>sa -P password
> mailnew.cmd
>
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart