Re: Emerald Help

Dale E. Reed Jr. ( (no email) )
Wed, 11 Nov 1998 12:55:47 -0800

> Jack Payne wrote:
>
> I need some help on Emerald:
>
> 1) Is there any way to get our address on the e-mailed invoices we
> send out

You can create three files in the emerald directory: invhead.txt,
invbody.txt and invfoot.txt, that will be put in the top, middle
and bottom of the emailed invoice.

> 2) Can someone give me a script to change all accounts from printed
> invoices to e-mailed invoices

Update MasterAccounts Set SendMethod = 1

> 3)Can someone give me a script to change the service type from one
> service to another

Update SubAccounts set AccountType = 'xxxxx' where AccountType = 'yyyy'

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com