[Emerald] About to Expire email message

Bob Dozier ( (no email) )
Tue, 22 Jun 1999 18:01:01 -0500

We are using SQL 7.0 and NTMail as our mail server. How does Emerald
send email invoices and incidents, with xp_send_mail? I can't find any
stored procedures to use as an example. Using Dan Tang's "rebatch behind
the scenes" procedure, we are attempting to give a "heads up" email message
to all accounts that are about to expire. Using exec xp_startmail, we get

Starting SQL Mail session...
Error: 17903, Severity: 18, State: 1
MAPI login failure..

I have not set up Outlook on the SQL server thinking that Emerald is
currently sending mail somehow as it is configured now. Anyone doing
this already?

Boy, these users get upset when they're locked out "without notice" even
though they get a printed invoice each month for payment due. :-)
Bob Dozier rwdozier@apex2000.net
Apex 2000 Internet Services Corporation Phone: (915) 570-1676