Queues > Queue Screens > Collection Screen Group > Collection Queues Screen > Summary tab

Mail Merge letters are an important part of collection efforts. If an employee can't reach a borrower through calling, they can create a letter to send to borrowers about unpaid account balances, delinquent accounts, upcoming repossessions, or other negative activity occurring on their account.

IMPORTANT: Your institution must have institution option CQMM (Use Collection Queue Mail Merge System) set up in order to create mail merge letters from Collection Queues. Contact your GOLDPoint Systems account manager if you would like this option set up for your institution.

The actual content of letters is determined by your institution. Generally, setting up a Mail Merge letter in Microsoft® Word only needs to be done once for each type of letter. After that, the merge information can simply be assigned to merge letters, as explained in the following instructions.

	Note: These instructions are for Word 2013. The steps may be slightly different if using earlier or more recent versions of Word.

Access the Queues > Collection > Collection Queues screen in CIM GOLD.

Select the queue you are working in the Collection Queues list.

Right-click the selected account(s) and select "Create Merge Fields" from the pop-up menu, as shown below:

The Create Sample Collection Queue Merge File dialog will appear as shown below:

Using this dialog, select the location to save the merge fields. This file, when created, does not contain personal customer information. It only creates the merge fields needed in creating a merge document in Word.

Click the Mailings tab, and then click Select Recipients. Select "Use an Existing List" from the list of options (see below).

The Select Data Source dialog box appears. Find the merge fields data file saved in step 3 above. Open the file.

selectdatasrce_colqs

Merge fields can now be inserted into the letter that will match up with CIM GOLD information.

	Note: If you have any errors trying to load the merge fields, try opening the merge fields file in Excel and saving it as an Excel spreadsheet. Then repeat steps 6 and 7 and select the Excel file instead of the text file (Excel spreadsheets have the extension of .xlsx).

The following steps explain how to insert merge fields. For a list of all possible merge fields and how they match up to fields in CIM GOLD, see Merge Fields in Collection Queues.

Place your cursor where the first merge field will go.

On the Mailings tab, click Insert Merge Fields, and from the list that appears, select the merge field to insert.

10.

The merge field now appears where the cursor was. Continue adding merge fields throughout the document where information from CIM GOLD will be inserted, as seen in the following example (merge fields have a gray background):

11.

Save the Word document. It is recommended you save it with the same name as the collection queue (e.g., Repossession Letter, 90-days delinquent, etc.).

12.

Close the Word file. Merge letters cannot be printed in CIM GOLD if the Word document is open. Now the letter can be combined with actual borrowers' information using CIM GOLD.

13.

From the Collection Queues screen on the Summary tab, right-click on the list of accounts for which you want to send a collection letter. You can select one account, a group of accounts, or all accounts.

Tip: If you want to send a letter to all the accounts in the queue, press <Ctrl> + A to select all the rows.

IMPORTANT: When more than one account is selected on the Summary tab and more than one account owner is listed on the account, the system creates a letter for the IRS account owner only. Therefore, if you need to create a mail merge letter for each owner on the account, you will need to select the accounts individually, as explained in steps 15 and 16 below.

14.

Select "Mail Merge." If you only selected one account, the following dialog box appears listing all the names on the account:

If you selected a group of accounts or all accounts, skip to step 16.

15.

Check the box next to the names for whom you want to send a letter.

16.

Click <Print>. The Open dialog box will appear.

17.

Find and select the letter you created previously (from steps 5-11 above), then click <Open>. The letters will automatically be printed to your default printer.

	Note: When more than one account is selected on the Summary tab and more than one account owner is listed on the account, the system creates a letter for the IRS account owner only. Therefore, if you need to create a mail merge letter for each owner on the account, you will need to select the accounts individually, as explained in steps 14 and 15 above.

18.

If in step 14 you clicked <Open Merge Document in Word> instead of <Print>, the letter appears in a Word preview screen. From this screen, all the letters selected in the list can be printed, but changes cannot be made from the Print Preview screen.

This letter can be used again and again by anyone at your institution using the CIM GOLD Mail Merge function.

Due to the nature of the Mail Merge function in Word, sensitive and personal information is only temporarily saved to a file on your computer until the preview screen is closed or the letters are printed. CIM GOLD then deletes the temporary file containing sensitive information.

Once a letter has been printed for accounts, "Mail Merge" will be displayed under the Disposition column on the Summary tab list view.

Options

The following options affect mail-merge letters from queues:

1.Institution Option CQMM (Use Collection Queue Mail Merge System) must be set up in order to create mail merge letters from Collection Queues.

2.Institution Option MSSN affects how Social Security numbers are printed on Mail Merge letters. When this option is set, the Social Security number will print with XX’s in the first five leading spots of the Social Security number and the remaining four numbers will print as normal.

3.A Collection Institution option is available that causes the system to use the mailing address attached to the account, rather than the mailing address attached to the name, when creating mail merge letters from the Queues > Collection > Collection Queues screen. The option is available in CIM GOLD version 7.8 and above. You can set the new option, Use Account Address for Mail Merge, on the Loans > System Setup Screens > Collection Institution Options screen.

If the account you are sending a letter to does not have a Mailing Address (NTADDR), the Property Address (NTPADD) will be used instead. If neither a Mailing Address nor Property Address is on the account, then the system will use the Mailing Address (NDMLAD) attached to the name not account.

4.After letters are printed, a note can be written in the Contact tab of the Loans > Marketing and Collections screen indicating that a mail-merge letter was sent to the account owner. To add this note to Comments, your institution must have an option selected on the Loans > System Setup Screens > Collection Institution Options screen. The option is called Contact Queues Write Notes to Collection Comments.

See the following example of the mail-merge letter comment:

Comments Screen from Options > Show Collection Comments

Creating Mail Merge Letters

Creating Mail Merge Letters