Go out of billmenu & come back in.

1. Calculate .auxcredits for the term you want to bill. Use DMS:SORT to find the students who should receive a bill.  You should sort STUDENT for auxcredits, not STUBAL.  For the Email statement to work, the pointer must be built to STUDENT.  After charges have been applied by the running of Real statements, if you want to send statements to students with .ctbalance in specific ranges you have to sort STUDENT with a translation to STUBAL to get the .ctbalance.
2. Use DMS:SAVE  to save the pointer file.  Name it STATEMENT.
3. Mainmenu, Bill, Group – to run statements for printing.  Follow your normal procedure for printing & mailing.
4. Mainmenu, Bill, Email – to run statements to email them.  For now, you’ll need to do these in 2 steps, one after the other.  Wait for one to finish, though, before starting the other.  Eventually, you might get clearance to use paper statements for those without email addresses.  That will require a slight modification of the programs used here.  Contact the system manager if/when this becomes necessary.

Term to report <043S>? 052s

Paper Type for STATEMENTS <HP12ADM>? -1

Subject Line for E-mail? Your SGU Statement of Account

Do you want to use the SET sub-option <NO>? YES

The valid SET sub-options are:

        ADJUST    To adjust Financial Aid awards as needed

        ADVANCE   To control printing of advance payment totals

        ALL       To print more than new transactions

        ESTIMATE  To do an estimate bill

        LIQUIDATE Credit all eligible Financial Aid awards to students

        LOCK      Credit eligible Aid awards to students

        NEW       To print only new transactions

        NOCHANGE  Do not print bill if no new transactions

        REAL      To do a real bill

        SCHEDULE  To control printing of student schedules on bills

        <RETURN>  To get out of the SET option

Current defaults are:

       ESTIMATE NEW SCHEDULE

Enter the requested option? EST

Continue to print estimated statements <NO>? YES

The valid SET sub-options are:

        ADJUST    To adjust Financial Aid awards as needed

        ADVANCE   To control printing of advance payment totals

        ALL       To print more than new transactions

        ESTIMATE  To do an estimate bill

        LIQUIDATE Credit all eligible Financial Aid awards to students

        LOCK      Credit eligible Aid awards to students

        NEW       To print only new transactions

        NOCHANGE  Do not print bill if no new transactions

        REAL      To do a real bill

        SCHEDULE  To control printing of student schedules on bills

        <RETURN>  To get out of the SET option

Current defaults are:

       ESTIMATE NEW SCHEDULE

Enter the requested option?

Batch file USERS1:[SBR_FLOY]EMAIL_STATEMENT.COM; created   03:27 PM

Queue the batch now <NO>? YES

Batch Queue <SYS$BATCH>?

Time to start the batch <NOW>?

Job EMAIL_STATEMENT (queue SYS$BATCH, entry 95) started on SYS$BATCH

A file named email_statements.lis will be created in your directory.

To make sure the file has been created:

SBR_FLOY>dir *email*/since=today/date

Directory USERS1:[SBR_FLOY]

EMAIL_STATEMENT.LOG;6

                     23-JUN-2005 15:27:16.37

EMAIL_STATEMENTS.LIS;1

                     23-JUN-2005 15:27:23.72

Total of 2 files.

SBR_FLOY>

To view a few of the statements:

SBR_FLOY>type/page=save email_statements.lis

To actually perform the email function in this test:  (after you see how it works, we’ll embed this step in the program so it won’t have to be done manually.)

SBR_FLOY>run dms:emailer

MASS_EMAILER V1.0-01 - Parse/Send E-mail                    03:33 PM

Building Blocks Copyright (c) 2000, Campus America, Inc.

Text File to Process? email_statements.lis

Default Subject Text? test email

Finished    03:44 PM

If an email bounces, it will come back to your Outlook inbox.  You’ll have the option of doing nothing or forwarding it to Registrar for correcting email address.