Yes. The only one it wouldn't work with is Post.Office (because it
uses the sanew field).
> Also, where do you put the new user test file that you want to be sent?
You can modify the proc to be a fully qualified path to newuser.txt.
> Is this a script that has to be run manually, or will it just send these letters automatically?
You could configure SQL Executive/Agent to run it once a night if you
> *********** 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 = 'blat newuser.txt -t ' +
> > CASE WHEN EMAIL is not NULL then Email ELSE Login + '@' + d.MailDomain
> >END +
> > ' -s "Welcome to my ISP" -f "email@example.com" -s 188.8.131.52'
> >From MasterAccounts ma, SubAccounts sa, Groups g, Domains d
> >Where ma.CustomerID = sa.CustomerID
> > and ma.GroupID = g.GroupID
> > and g.DomainID = d.DomainID
> > and sa.AccountType in ("PPP", "ISDN")
> > and sanew <> 0
> >Update SubAccounts
> >Set sanew = 0
> >Where AccountType in ("PPP", "ISDN")
> >Then use an SQL7 bcp command in a batch file like:
> > 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:
> For more information about this list (including removal) go to:
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