Re: Emerald Help

Jack Payne ( (no email) )
Wed, 11 Nov 1998 14:30:27 -0700

Thanks Dale for all the Help

-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Wednesday, November 11, 1998 1:58 PM
Subject: Re: Emerald Help

>> 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
>
>For more information about this list, including removal,
>please see http://www.iea-software.com/maillist.html
>