Re: [Emerald] About to Expire email message

Dale E. Reed Jr. ( (no email) )
Tue, 22 Jun 1999 16:37:46 -0700

Bob Dozier wrote:
> 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

No. Emerald has a built in SMTP client that is uses to send email.

> 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?

You need to. Thats the key to using the proc. Emerald doesn't need it,
but that proc does.


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.