Re: simple question about Emerald and P.O.

Dale E. Reed Jr. ( (no email) )
Fri, 14 Mar 1997 13:28:57 -0800

Josh Hillman wrote:
> Dale, thanks for the info on the Emerald/PO integration. Before I attempt
> to create a new account (along with the mailbox), do I need to make any
> changes to the existing MBR or SubAccount records so that when I run the
> email batch-job, there are no conflicts with existing mailboxes? There are
> a few hundred subaccounts (most have email addresses listed in the Services
> area) and I just want to make sure I'm not going to screw up any existing
> mailboxes.

Just create a new test service under your MBR. That would be the best
to test it. Also make sure that you have select the ES for Post.Office
fot that account type in Emerald Admin, or it wouldn't export it.

> Is "postmail.exe" still necessary in the emerald directory or does Emerald
> now use its own SMTP agent?

Emerald uses a built in SMTP client to send the mail.

> Also, what causes the "SQL Error" when clicking on the Batch tab from
> within Emerald? I've noticed this on .75, .90, and .92. I seem to recall
> someone mentioning that a misconfigured "ExternalTrans" table would cause
> it. Mine has the column names in it, but no data (rows).

When you click on the batch tab, its lookin in the External Trans
table for bad batches. Have you compared your ET table to the
insttabs.sql? What about permissions?

> The reason that I have an email address listed for each service is so that
> when I mail all of our users, I just run this quick script,
> select mail from subaccounts where mail != "" and active = 1
> then take the output and copy/paste it into the forwarding addresses area
> of an account that I create temporarily (like When I
> send off the message to the users, I then delete the account and just
> repeat the process whenever I feel like broadcasting a message. I delete
> it because I don't want anyone else to be able to send mail to everyone...

This is fine. Email addresses override the defaults you setup for the
group's domain.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |