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
want.
> 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 = '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 = 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")
> >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
--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