Multimedia Presentation



If video is not visible above this line, then check whether content has been blocked...

Merge Steps

  1. Right-click the Result tabs in Calin Professional.


  2. Click "Copy MS Word Merge Data location to clipboard".


  3. Select "Tools" menu item in MS Word 97.


  4. Click the "Mail Merge..." item in that menu.


  5. This opens the "Mail Merge Helper" dialog box.


  6. Click the "Create" button and choose "Form Letters".


  7. You will be asked what document to use for the form letters. In this example, select "Active Window".


  8. Now click the "Get Data" button and choose "Open Data Source".


  9. Now you will see the "Open Data Source" dialog box.


  10. Place the cursor in the File name edit box, and press Ctrl+C keys. This will paste the filename that you copied at the start.


  11. Click the "Open" button. The box will close.


  12. If you have started with a fresh document then you will be given a message that there are no merge fields in your main document.


  13. Click the "Edit Main Document" button. This will close all dialog boxes and return you to the document.


  14. Click the "Insert Merge Field" which should be on the main toolbar.


  15. Select a field and click "Insert". Repeat this for each required field.


  16. Select "Tools" menu item again.


  17. Click the "Mail Merge..." item in that menu.


  18. This opens the "Mail Merge Helper" dialog box again.


  19. Click the "Merge..." button.


  20. This will open a "Merge" dialog box for selecting the merge records.


  21. Click "Merge" to complete the operation.


Available Merge Fields

FIELDEXAMPLESHORT DESCRIPTION
af22/09/2007Accumulation Start Date
apd$1.47Interest Accumulation per day
apd_wone dollar and fo...Interest Accumulation per day (words+number)
apdwone dollar and fo...Interest Accumulation per day (Words)
applyorder Debits and Cred...CR & Dr Application Order
cend21/09/2007Calculation End Date
clb$7,701.03Closing Balance
clbwordsseven thousand se...Closing Balance (in words)
cli$568.34Closing Interest
cliwordsfive hundred and ...Closing Interest (in words)
clnp$0.00Closing Non-Principal
clnpwordszero dollars and ...Closing Non-Principal (in words)
clp$7,132.69Closing Principal
clpwordsseven thousand on...Closing Principal (in words)
dpy365Days per Year
dyrs3.177Years in Interest Period
end21/09/2007Interest End Date
idebited$0.00Credits Paid
ipaid$428.34Debits paid
MsMergeC:\Documents And ...MS Word merge file
RatesUsedInterest rate 7.5...Interest Rates Used
ReferenceCalculation 001User Reference/Case Name
repayc0Number of Repayments
repayments Total $0.00Repayment Schedule
settingsProgram Settings
sp$950.05Starting Principal
start16/07/2004Calculation Start Date
STD_AUTO(a) On 16/07/2004...Standard Text Report (with preferred numbering)
tdays1163 daysDays in Interest Period (numeric)
ti$996.68Total Interest
ti_wnine hundred and ...Total Interest (number and words)
tiwnine hundred and ...Total Interest (in words)
TXROSTERBDATE DESCRIPTION...Transaction Roster (no numbering)
TXROSTERBHTML
HTML Table Report