ECSI Newsletter
March-April 2001 Volume 2, Issue 2

Inside this issue:




Close Out Dates

These are the close out dates for the next three months.

  Mar Apr May
Mid-month Billing Calc 13 12 14
End-month Billing Calc 30 30 31
Final Transmission date for reports 30 30 31
Reports mailed to schools 4/2 5/2 6/2


[Back to Top]


SAL Windows Update

Below you will find some of the recent changes to our SAL for Windows software. Many of these changes are the result of client requests. We're always open to your input to keep SAL the best product available.

Stop Code Window Changes

The Stop Code Window has been changed to include the following new fields:
  • Auto Agency Turnover
  • Clearinghouse

These new codes can be set for a number of temporary months (1-9), or can be set to permanent stop by checking the ‘permanent’ box.

Stop Code Window



[Back to Top]



Loan Type Information Enhancement (INFO Button)

On the Primary Window in SAL we have added a new button, (INFO). This button is located below our help button. The window consists of 4 different list boxes, eligible deferments, eligible partial cancellations/postponements, eligible 100% cancellations and other parameters. All of this information is pulled in from our Fund Parameters area. The information on this window is associated with the highlighted loan on the primary window. The other parameters area lists some of the most important parameters associated with the highlighted loan type; minimum fixed payment, original grace period months, interest rate, accrue penalty/late charges and if so how much for the first month or there after, plan type, small balance payoff and when to turnover the loan to the credit bureau and if so at what months delinquency. If the penalty/late charges are set to “no”, then the “charges first month” and “charges there after” lines will not be displayed. Also, if the credit bureau is set to “no”, then the “turn over months” line will not be displayed.

Info Button Window



[Back to Top]



Changes to Name and Address

The Name and Address window has been modified to allow the user to enter up to ten (10) characters for the address change source. This allows unlimited flexibility when adding a new source for each address change. This replaces the single character method originally previewed in our window's project.

Name and Address Window



[Back to Top]



Cohort Months Delinquent

ECSI has added a new field to the Primary Window in the months delinquent area. When you access an account that is in "this years" cohort population, the description will display COHORT MONTH DEL instead of MONTH DEL. The first field represents the number of months an account is delinquent for cohort reporting purposes. The second field identifies months delinquent that are used for credit bureau and aging reports.

Why would there be a difference between the two? Section 8 in the Federal Student Financial Aid Handbook provides the reason. The "Rules For Calculating The Number Of Days In Default" example reveals we must reduce months delinquent for each full installment that was paid for cohort reporting. This means if a check is received for $400 on a past due account and the entire amount was applied to interest and fees, the cohort months delinquent must be reduced by 10 months. ECSI disagrees with this aging method and will continue to discuss with DOE. We have asked several schools, competitors and auditors about this process and every one agrees with our standard calculation.

A new field was required because when a payment is made, months delinquent is reduced based on the number of principal installments that were paid. As you can see in the example above, if we reduced months delinquent based solely on the number of fixed payments that were made you could easily have a situation where monies appear in 15-, 45-, 75-, etc., days past due and months delinquent could be zero. A new field was needed in order to keep the integrity of the aging fields intact and provide you with the advantages of a lower cohort default rate.

Pictured on this page is an example of the COHORT MONTH DEL field which shows a value of 5 for cohort and 7 for months delinquent. Prior to the last payment the borrower was past due 8 installments. When a payment of $120 was made, $80 was applied to interest and $40 to principal. As you can see, months delinquent was reduced by 1 (from 8 to 7) and cohort months delinquent was reduced by three (from 8 to 5) because three full installments were paid.

Cohort Window



[Back to Top]



Document Writer - Common Problems

Problem # 1:
  • “Record 1 contains too many fields” - This problem is caused by the letter being converted to Word 2000 from an earlier version such as Word 97.

Solution:

  1. As soon as the letter is opened, this message box will appear. Click on ‘Ok’ in this message window to remove it. (It may display twice).
  2. Click on the ‘Edit Data Source’ button on the Mail Merge toolbar.

    Document Writer Window

  3. The ‘Edit Data Source’ window will now display.

    Document Writer Window

  4. Click on the ‘Ok’ button on this window. Word will now convert the file into the correct format.
  5. Save the letter before continuing.

This problem will only occur the first time you open a letter with Word 2000 that was previously opened with Word 97.

Problem # 2:
  • “let_xyz.doc is a mail merge main document. Word cannot find its data source, MERGE.DOC” - The file that is created by Sal and passed to Word that contains the information for the letter is missing or not created.

Document Writer Window

Solution:

  1. Did you generate the letters from within Sal?

    Document Writer Window

  • No - Repeat all steps of the letter creation process.
  • Yes – The Merge file is not setup correctly for this letter.
    • Click on ‘Find Data Source’ from the message window.

      Document Writer Window

    • Enter ‘C:\SAL-TEMP\MERGE.DOC’ in the filename box. Document Writer Window
Problem # 3:
  • “Word could not merge the main document with the data source because the data records were empty or no data records matched your query options”- There is a code at the top of each letter that must correspond with the three digit letter code from Sal. If this code does not match Sal, this letter will not be created.

Document Writer Window

Solution –

  1. Click on the‘Ok’ button to close this message window. This will bring you back to the letter document.
  2. Right-Click on the field {Skip Record If} at the top of the letter and click on ‘Toggle Field Codes’ from the pop-up menu.

    Document Writer Window

  3. The {Skip Record If} should now change to a line that looks like the following:
    { SKIPIF RH0 <> "RH9" }

    The value at the end of the line,“RH9”, is the code that should be an exact match to what is within Sal and the Word document name. In this case it does not match since the code says “RH9” and the letter is“RH0”. Place your cursor in this field and correct the value so that it would match. { SKIPIF RH0 <> "RH9" }

      1. This field must be three (3) characters (spaces are ok at the end. Ex“RH “)
      2. The values in this field must be in all caps. (“rh0” is not valid)
  4. Save the letter before continuing.
Problem # 4:
  • “The same info/data/junk prints on all of my letters” – The document template that is used to merge all of the letters has been modified and saved.

Solution:

    1. Open the document, and remove the incorrect information from this template.
    2. Save the letter before exiting.
Problem # 5:
  • “As soon as I open the letter in Word, it looks like it’s already been merged” – There is a button on the Mail Merge Toolbar that allows you to view what the letter will look like after the merge has been completed.

Solution:

  1. Check to see if this button is clicked on by mistake.

    Document Writer Window

    • Click the {ABC} button off if it is activated.
  2. If this button is not turned on, have you over-written this template document with a previous merge that they might have run? If so, the letter will need to be recreated since it is no longer a mail merge file. (If you ran a ‘Merge to New Document, and saved the results as the original document.)
Problem # 6:
  • “Cannot launch MS Word at this time” – The Word document that the user is attempting to open cannot be found in their SAL-SYS\LETTERS directory. If the user is trying to open their letter XYZ, there should be a Word file called LET_XYZ in the SAL-SYS\LETTERS directory.

Document Writer Window

Solution:

  1. Click on"Open Letters Window” to view all of the Word documents the users has saved on their system. Document Writer Window
  2. You should now see the window listing all of these documents. Browse thru the list to verify that the letter is in this area and is named correctly.
    • If the letter is not located in this folder, you do not have this letter and would need to have it created before continuing.
    • If the letter is there, but the name is not in the correct format:
      • Right click on the icon representing the document and select ‘Rename’. Document Writer Window
      • Enter the correct name and press enter (Format is LET_XYZ.DOC)

    Document Writer Window

Problem # 7:
  • “File Conversion Box displays when attempting to open the letter or exit interview” – This is another issued caused by Word 2000.

Solution:

  1. Click on ‘Plain text’ and press ‘OK’

Document Writer Window


[Back to Top]

Automatic loan balance payoff

Several months ago it was brought to our attention that we didn’t need to “offset” monies when creating a low balance payoff. We researched this and agree. Therefore, in the future all low balance payoffs will be one-sided entries. In other words, Principal will be the only general ledger entry in all future low balance payoffs. This adjustment will continue to generate a “positive” credit bureau status.


[Back to Top]

Regulations and Current Events

And now for the rest of the news...

Education Budget Initiatives

On February 27, 2001, President George W. Bush provided some details of his education budget initiatives.

While many of the funding increases were directed to primary or secondary education programs, there were a few items targeted to higher education. Bush proposed an additional $1 billion to increase the maximum Pell Grants awards. An additional $64 million is proposed to increase teacher loan forgiveness limits to $17,500, up from the current $5,000.

In total, the president's proposal would add $4.6 billion for fiscal year 2002 over fiscal year 2001. Although education received the largest increase of any cabinet agency, many have expressed disappointment. Democrats in congress were anticipating approximately $10 billion in increased appropriations.

Privacy Initiatives

Privacy initiatives have received the serious attention of both houses of the 107th congress.

The Republican Main Street Partnership, headed by House Energy and Commerce Telecommunications and Internet Subcommittee Chairman Fred Upton (R-MI), announced that its priorities will include privacy as one of their top issues.

Their belief is that all privacy bills should include provisions requiring websites that collect and use personal information to provide a clear and conspicuous privacy notice to site users.

The partnership strongly encourages industry to embrace self-regulation and address consumer privacy concerns through third party seals and enforcement.

In addition to partnership, there has been much activity in Washington regarding privacy. In February, two privacy bills (S.290 and S.324) were introduced in the U.S. Senate. The Privacy Coalition, whose members include the ACLU have issued congress a challenge to meet "The Privacy Pledge", a standard for the future protection of privacy.

Finally, President Bush has postponed the enactment of the Patient Privacy Regulations.

Up to the minute coverage of this very dynamic issue can be found on our web site in either the "Headlines" or "Legislation" sections.

Plan to Boost Pell Grants

CEF Unveils Five-Year Plan to Boost Pell Grants to $10,000.

Last week, the Committee for Education Funding (CEF) unveiled its plan to raise the maximum Pell Grant award to $10,000 over the next five years, a substantial increase over the current $3,750 maximum award. In total, CEF’s proposal seeks to raise federal education spending from $39.3 billion this year to $109.6 billion by fiscal year 2006. At current funding levels, two cents of every dollar are spent on education. CEF’s plan, dubbed “Five Cents Makes Sense for Education,” calls for education spending to reach five cents of every federal dollar spent.

1098-T Reporting

This year ECSI provided 1098-T service to 7 schools. We used this year as a beta test for next year. Our processing went very well and we will actively pursue all of our current clients for this business. Similar to our 1098-E program, we provided the following:

  • send file in the format prescribed by the IRS
  • send each student, provided by the school, a Form 1098-T. Our form included instructions for filing and the website for the entire IRS publication on both the Hope and Lifetime Learning Credits
  • creates a student database that allows changes/updates to the student information originally provided. This database can be accessed by SSN# and name.
  • creates a report of all borrowers reported to the IRS (and also received 1098-T forms)
  • allowed borrower access (via their unique PIN number) to the 1098-T information on our website.
  • Provided a CD-ROM of all 1098-T’s and the report.

[Back to Top]

Help Desk

ECSI has recently implemented our new HelpDesk System. The goal of our HelpDesk is to better serve you, our customers. The HelpDesk works as follows:

  1. You will continue to call our account representatives. They will attempt to answer all processing- type questions.
  2. If the issue is system or program related, we will log this into our HelpDesk.
  3. The HelpDesk coordinator will assign each task to one of the following: Administration, Programming or Operations. Each issue logged is tracked daily and reported by the category of completion: Assigned, Pending, Waiting on School or, Completed.
  4. Once the issue has been resolved, the HelpDesk Coordinator will contact you with the resolution and close the item from the "live" HelpDesk application.
  5. All of your enhancement requests will also be logged into our HelpDesk. Each week, we meet with our Programmers to discuss your ideas. You will be kept abreast of the status of your requests.

ECSI will now be able to track the following:

  • Calls from a specific school.
  • Calls logged for any given time period.
  • Calls for repeated issues.

This new system is our attempt to provide better service, in a timelier manner. Each day we review the HelpDesk report and attempt to limit the amount of time any issue remains "open". If the issue will take time, our goal is to respond by phone or e-mail, and give a projected date of completion. Once resolved, we will call and advise you that the issue is complete and confirm that you are satisfied with the results. Please feel free to offer your input, this is your tool!


[Back to Top]

2001 User's Conference

It's that time again... Time to make your plans to attend ECSI's 2001 User's Conference. This year promises to be better than any ECSI conference to date. We have prepared a list of presentations and sessions that will satisfy the most voracious appetite for knowledge. This year we will be inviting several guest speakers from various sectors to address important issues. Of course we will cover everything you need to know about SAL for Windows and our Internet technologies.

The conference will be held at the Pittsburgh Sheraton, Station Square from April 23rd to April 25th.

ECSI has guest rooms reserved for the conference at a discounted rate. When placing reservations, please mention the ECSI User Conference. Rooms are limited and are on a first come, first serve basis. Rooms will be blocked until March 20, 2001. These rates are good for Saturday, April 21 through Wednesday, April 25. The hotel rates for each day are:
      Single or Double occupancy: $122.00
      Triple occupancy: $137.00
      Quadruple occupancy: $152.00

Make reservations directly with:
      Sheraton Station Square Hotel
      7 Station Square Drive
      Pittsburgh, PA 15219
      Phone: 800-255-7488 or 412-261-2000
      Fax: 412-261-2932
      Web:
Sheraton Station Square

     2001 Conference Information


[Back to Top]



Internet News

What's happening with ECSI's web and Internet services

For all the latest additions and changes to our web site, make sure you sign up for the "Web Site Update Notification". You will receive an email every time we make noteworthy changes to the site. You can sign up by going to the "Clients" page (more details in a minute). Alternatively, you can review the changes at any time by following the "Site Changes" link on our main table of contents.

DirectPay Enhancement

Its only been two months but things are already changing with the DirectPay service.

The response has been unbelievable. We have hundreds of people signing up to use this new service. No other web feature has drawn this much attention so quickly.

We have received over fifty suggestions from borrowers for changes to the system. The overwhelming majority have requested more frequent withdraws as their most important request. If that many people took the time to comment, it must be important!

Starting March 9th, we will begin drawing monies every Friday. When a borrower signs up for DirectPay, they will be shown their school's anticipated draw date (either the 1st or the 20th). If they do nothing, this will be their payment date.

Immediately below the anticipated draw date, they will be presented with a choice of the next four Fridays. They can select any of those Fridays as their payment date.

The benefits will be:
  1. Borrowers can make 'last minute' payments.
  2. It allows borrowers to schedule payments that are convenient for them, based on their other bills or pay days.
  3. Borrowers can make multiple payments in a month to better manage their cash flow.

For our clients, we will begin populating the DirectPay information into SAL in the ACH fields of the 'Name & Address' window. Comments will be cut any time a borrower adjusts their web information. If you update daily with ECSI, you should see any changes within one business day. Now you can see the web-based DirectPay activity right along side the rest of the SAL data.

[Back to Top]

New Borrower Site: Part Two

In an effort to encourage borrowers to clean up their demographic information, we are now displaying a rather bold 'stop sign' icon when any part of a borrower's address is potentially incorrect. Any borrower address coded as 'Bad' will be flagged with the new icon to draw the borrower's attention to the problem. They are given a link to quickly update their demographic information. The icon is displayed on any page where a borrower's demographic information is relevant (loan status, DirectPay, etc). In the short time it has been available, address corrections for this small population of web visitors are up by almost 15%. More than 40% of the borrowers corrected their address the very first time the icon was displayed!

If the address is correct but we are missing a phone number or date of birth, we display a somewhat less obnoxious 'Yield' icon along with a request for the borrower to update their information. We're hoping to get the same level of response from the yield icon as we have received from the stop icon.

Borrower Forms:

One of our "future enhancements" in the last issue was to expand the number of formats for our on-line Borrower Forms. Several borrowers have complained about needing to upgrade or install the PDF plugin. In February, we released the first set of new formats. To accommodate the many needs and preferences, each form is now available in several formats.

  • PDF forms are by far the most accurate to reproduce on a printer. They also offer the ability to fill-in portions of the form prior to printing. For all their advantages though, some versions of the Acrobat plugin have problems with different versions of Windows or even different versions of the same browser.

  • Plain HTML is the most basic form and is readable by every version of every browser. Unfortunately, it produces the least accurate output to a printer. The forms simply do not look very professional.

  • HTML CSS and HTML Layers are in between Plain HTML and PDF. CSS is supported by both Internet Explorer and Netscape (version 4.0 or later). Layers are supported only by Netscape. Either CSS or Layers gives a reasonably close representation of the form without requiring downloads or plugins. These forms will soon be integrated into the borrower's on-line application, allowing a portion of the information to be filled in prior to printing.

  • GIF/JPG are images of the forms. These are the largest in size but have a wide range of support for browsers and printers. These forms generally produce quality similar to a PDF. The downside is they may be four to twelve times larger than the other formats. When all else fails, the GIF/JPG forms will almost always display correctly.


[Back to Top]

Client On-Line Services

In the initial paragraph we mention email notices. Here's a new twist to an old feature. You can now stipulate how often you would like to receive your update notices. Some people don't like to be notified every day. Others would rather not wait for a monthly or even weekly notice. Since there was no "one size fits all" answer, we have changed the notification system to let you select the frequency that's right for you.

You can sign up for the update notices directly on the Client page. Under On-line Services, look for "Notify Me!".

You may remember the "Client Application" which we labeled "your gateway to ECSI's interactive services". Previously, that was where you could look up a borrower's web account or sign up for email notifications. Sadly, the "Client Application" is no more. While the application served us well for the last 18 months (an eternity in 'Internet Time'), it had fallen far behind in technology and extendibility. Not only that, it was incompatible with our new borrower application and I'm surprised how many of you noticed the day I broke it!!

We have replaced each of the functions in the Client Application with equivalent functions under the On-Line Services portion of the Client page (see picture). Now you will find an improved version of the "View Borrower Account" page. There is now a new function to "View Borrower's Tax Forms". Finally, you will find the improved version of our Email Notification under the "Notify Me!" link.

Client Page

The new client functions were created using the same technology as the borrower application. What this means is that new or enhanced features can be added almost anytime without long downtimes in the service. Plus, updates can happen without taking the entire web site down (a big deterrent to doing frequent updates). A final advantage is that all the security features available to borrowers are now available to clients. These include: encryption, support for multiple logins and multi-level security access. Enhanced security will finally allow us to provide clients with access to information that was previously much too sensitive to place on the web.

Client Page Changes:

If you take another look at the picture above. You will see several changes to the organization of the client page.

Under the Information heading, you will see that each item (except the User Conference) has a date of last update. Even the Site Changes are available directly from the Client page. We hope that the client page will serve as your 'one stop shopping' to all the areas of our web site relevant to our Clients.

Notice the new "Headlines" topic. Here we have a collection of articles from across the web on any subject that is even remotely of interest but didn't fit into another category. We scour over 60 different sources to collect information that may be of interest to you. The Headlines section is updated at least twice a week when there is relevant news.

Finally, you can see the new "SAL Changes" topic. Here we will bring you up to the minute documentation on the changes in the software. Many of you receive program updates every day during your daily update. The "SAL Changes" page is our way to notify you of new or improved features or even just simple changes to the SAL software.

[Back to Top]

SAL HelpDesk

The SAL HelpDesk portion of the client page has received some much needed attention. The entire on-line help manual is now available directly on the web. Every time we update the manual internally, the web version is updated that day!

We have reorganized the topics and have added a 'single-page view' of all the topics on file. Now, you can either drill-down through the categories or view all documents on a single page. The hope is to make the information easier to find.



[Back to Top]

More Details

If you've not already done so, consider joining us at our 2001 User Conference. We will present a more in-depth view of all our web and Internet services. We will have a formal session during the conference where we present many of our new services. We are open to extending the discussion to your specific questions, comments and suggestions during our Wednesday session.

There's still plenty of time left to sign up. Hope to see you in April!

Until Next Time

I hope you'll take a few moments to review the changes we've discussed this month. Our web site has a wealth of useful and relevant information for just about everyone. Any suggestions can be sent to Webmaster@ecsi.net. We are always looking for your prospective.

[Back to Top]



Learning Center

Having trouble keeping up with the latest changes in SAL? Let us point you in the right direction with our "How TO" documents.

Creating a New Letter

  • Click on Modify Letters, a window will appear displaying all letters on file
  • Click on New Letter, a window will appear asking for the letter information
  • Click on Accept, to save after entering all of the desired information
  • Click on OK, the information for this letter has been saved
  • Click on Quit, X or Esc to close the window
  • Click on Open Letters Window
  • Double click On Any Letter
  • Click on File
  • Click on Save As
  • Click on File Name (change your letter from Let_AA to Let_XXX, you can use a two digit and a space or a three digit field)
  • Click on Save
  • Right click on Skip Record If
  • Click on Toggle Field Codes
  • Change AA to XXX (UPPER CASE ONLY) (it must be the same as your file name, a two digit and a space or a three digit field)
  • Click on File
  • Click on Save
  • Make all of your changes to the letter
  • Click on File
  • Click on Save
  • Click on X to close the window
  • Click on X to close the window


[Back to Top]

Modifying an Existing Letter

  • Click on Modify Letters, a window will appear displaying all letters on file
  • Double click on the letter you wish to modify, a window will appear displaying the current letter information
  • Click on Change, enter any new information that you desire
  • Click on the Accept, to save after entering all of the desired information
  • Click on OK, the information for this letter has been saved
  • Click on Quit, X or Esc to close the window
  • Click on Open Letters Window
  • Double click on any letter
  • Make all of your changes to the letter
  • Click on File
  • Click on Save
  • Click on X to close the window
  • Click on X to close the window


[Back to Top]

Deleting an Existing Letter

  • Click on Modify Letters, a window will appear displaying all letters on file
  • Double click on the letter you wish to delete
  • Click on Delete
  • Sal will ask for confirmation before deleting the letter. Click on 'Yes' to delete the letter information within the Sal System
  • Click on OK, the letter information has been deleted from SAL
  • Click on Quit, X or Esc to close the window

Note: Sal can no longer create letters using this letter information, but the word processor's Merge Letter still exists. You will need to manually delete this file if so desired.

[Back to Top]

Generate Mass Letter Mailings

This function allows the user to set up a list of criteria that Sal will use to search the loan database and export the matching information to be used by the word processor to create the letter.

The first step in creating a letter is to enter the Letter Code. If you are unsure of the code, you can view all of the Letter Codes by right clicking in the Letter Code field and selecting List Letters from the Menu.

After selecting the Letter Code, you can define a Review Date for the letter and specify a fee to be charged to all of the accounts that receive this letter. If a letter has a default fee amount, it will be displayed here.

After the letter processing options have been set, enter in a desired Months Delinquency Range. If you do not wish to have a specific range, enter the values '000' to '999'. This will inform Sal that you wish to include all delinquency ranges in the search.

The next available option is Consolidating the Loans. Consolidation totals all of the selected loans and creates one letter with this information. If this option is not selected, a separate letter will be created for each loan type.

After the Months Delinquency & Consolidation options are set, you can pick and choose which search criteria that a loan must have in order to receive the letter. The available criteria are: Loan Status, Special Code, Campus Code, Fund/Type, Program Type, and Collector Code. You can specify which of the criteria you wish to use by placing a check mark in the corresponding box. If you do not wish to utilize one of the criteria, simply remove the check mark.

After a Check Box has been selected, you have the ability to select either a specific range or let the program use all of the available values. If the 'Specific' choice has been selected, a list of all available values will be displayed for you to select from. To select a value, double click on the corresponding line. An asterisk mark will signify selected values.

Once all desired values for each criteria have been selected, click on 'Accept Choices'. This will activate the selected search criteria values for processing.

A list box is displayed at the bottom of the window containing all of the accepted search criteria. This allows the user to double check that all of the desired values have been chosen correctly.

Search Criteria Choices: (remember to accept the choices!)
  • Loan Status - This allows you to choose the status codes of the loans. For example, if you wanted the letter to be created on all loans in repayment, you would select Loan Status 3. The Document Writer would only create letters for accounts with a status 3. All other accounts would be bypassed.
  • Special Codes - This allows you to send letters on accounts that have matching Special Codes. For example, if you wanted to send letters on all NL [New Loan] accounts, you would select the NL Special Code.
  • Campus Codes - This option allows a school with multiple campuses to send letters to accounts at a specific campus.
  • Fund/Type - This allows you to send letters to accounts that have a specific loan or fund type.
  • Program Type - This option enables you to send letters on certain program types. For example, creating letters for all Institutional Loan types, but not Campus Based loans.
  • Collector Code - This option allows you to send letters to accounts that have a specific Collector Code assigned to it.
Here's an example merge scenario:

To send a letter to all of the accounts assigned to my collector code that are in repayment and 1 month delinquent, complete the following steps:
  • Enter 1 to 1 in the Months Delinquent Range
  • Check the Loan Status option, double click on Loan Status 3, click on Accept Choices
  • Check the Collector Codes, double click on my Collector Code, click on Accept Choices
All of the desired criteria have now been selected.

After all of the desired criteria have been accepted and you are ready to search through the loan database, click on 'Process'. This function will read through all of the loans currently on file, and may take several minutes to run depending on file sizes.

Once the search has been completed, click on 'Generate Letters'. This will create the merge file in the correct format, for the word processor to assemble the letters. Once it is completed, a window will display showing the names of the letters created. You can double click on the letter name to open the document automatically in Word to complete the merge. After the correct letter has been opened, activate the Merge routines within your word processor to complete the letter.

[Back to Top]

Generate Individual Letter Mailings

This function allows the user to enter individual account numbers that are to receive letters. To change to the 'Single Account' window, push the 'Single Account' button or from the menu, select 'Process Type' and 'Single Account'.

The Single account window will now be displayed. Enter the Letter Code for the letter you wish to create. If you are unsure of the code, you can view all of the letter codes by right clicking in the Letter Code field and selecting List Letters from the Menu. You can also specify a review time and a fee to be charged to the account for the letter.

After selecting the Letter Code & options, enter the desired Account Number and press Enter. The address the letter will be sent to and all loan types will now be displayed.

You now have the ability to modify the following options on the window:

  • Address This Letter Will Be Sent To - If you wish to send the letter to a different address, use the arrow buttons to choose the available addresses for the account.
  • Available Loan Types - If the borrower has multiple loans, you can choose which loans should be included in the letter by clicking the check box beneath each loan type. (All loans are selected by default. Remove the checkmark if a loan is not to be used for the letter.)
  • Consolidate Loans - The last option is Consolidate Loans. This totals all of the selected loans and creates one letter with this information. If this option is not selected, a separate letter will be created for each loan type.

After selecting all of the necessary information, click on 'Accept' to create the merge file for the letter. You can continue to enter as many accounts as you wish by following these same steps over.

[Back to Top]


© Copyright 2002, ECSI
Page: newsletter/2001-01.html       Last Modified: 10/10/2002