RecoveryPro
             
  
RecoveryPro Home Page Features Pricing Updates Video Training User Manual Links ClientWatch Merge Field List Import Fields Frequent Questions TeamViewer Contact Us

Merge Fields for Your Mail Merge Documents

This page is still a work in progress.

Below are the queries set up in the QueryDB database for you mail merge documents. The QueryDB database is located on your computer (and workstations) at: C:\RecoveryPro\QueryDB.mdb

Use your Microsoft Word Mail Merge features to link to one of the queries listed below based on the document that you are trying to create. The merge fields are listed in BLUE. Where there is a screen shot, the fields are numbered on the screen shot in RED and the number is next to the field name in the list under the screen shot.

All the mail merge queries start with "GET" and are: Get CompanyInfo, Get Courts_Sheriffs, Get Garnishees, Get Mail Labels, Get Marked Accounts, Get Marked Creditors, Get Marked Debtor Exams, Get Marked Debtors, Get Marked Garnishments, Get Other Addresses, and Get Verify Debtor Address

Get CompanyInfo

This query will get your company information from your database (Preferences Screen).

  • 1  -  Company_Name - Your company information you registered with RecoveryPro.
  • 2  -  Company_Contact
  • 3  -  Company_Address1
  • 4  -  Company_Address2 - This is City, State, Zip
  • 5  -  Company_Phone1
  • 6  -  Company_Phone2
  • 7  -  Company_Fax
  • 8  -  Company_Email
  • 9  -  Company_WebSite
  • 10  -  Affiliation
  • 11ComputerName
  • 12  -  CoNameLH - This is letter head information for you letters - Company Name.
  • 13  -  ContactLH - Contact Name for letter head.
  • 14  -  Address1LH - Your address for letter head.
  • 15  -  Address2LH - This is City, State, Zip for your letter head.
  • 16  -  PhoneLH - Phone for your letter head.
  • 17  -  WebsiteLH - This is your web or email address on your letter head.
  • 18  -  EnvelopeReturnName - This is the return address you use on your envelopes.
  • 19  -  AgreeCompany - This is your company name for judgment assignments.
  • 20  -  AgreeState - This is your state for judgment assignments.
  • AgreeStateUpperCase - This is the upper case of #20
  • 21  -  AgreeType - This is your business type for judgment assignments.
  • 22  -  AgreeCourt - This is your court type for judgment assignments.
  • AgreeCourtUpperCase - This is the upper case of #22
  • 23  -  AgreeDays - This is the number of days until you pay OJC - assignments.

 Get Courts_Sheriffs

This query will get your county court information and your county Sheriff information from the Court/Sheriff Screen.

Get Courts_Sheriffs query also includes the CompanyInfo listed above.

  • 1  -  ListName - This name populates the list box on the Court/Sheriff Screen.
  • 2  -  County
  • 3  -  State
  • 4  -  CourtName1
  • 5  -  CourtName2
  • 6  -  CourtAddress1
  • 7  -  CourtAddress2
  • 8  -  CourtCity
  • 9  -  CourtZip
  • 10  -  CourtPhone1
  • 11  -  CourtPhone2
  • 12  -  CourtFax
  • 13  -  CourtEmail
  • 14  -  DistrictNumber - If your county has a district number, it is in this field.
  • 15  -  Prefix - This is for an case number prefix - if your county uses one.
  • 16  -  PostFix - This is for an case number postfix - if your county uses one.
  • 17  -  CourtOther1
  • 18  -  CourtOther2
  • 19  -  SheriffName1
  • 20  -  SheriffName2
  • 21  -  SheriffAddress1
  • 22  -  SheriffAddress2
  • 23  -  SheriffCity
  • 24  -  SheriffZip
  • 25  -  SheriffPhone1
  • 26  -  SheriffPhone2
  • 27  -  SheriffFax
  • 28  -  SheriffWebSite
  • 29  -  PrePay - This is the amount that you have to pre-pay your sheriff for service.
  • 30  -  SheriffEmail
  • 31  -  SheriffOther1
  • 32  -  SheriffOther2

Get Garnishees

This query will get your Garnishee information from your Garnishee Screen.

  • ListName - This is the name that populates in the list box on the Garnishee Screen.
  • FullName
  • Contact
  • Address1
  • Address2
  • Phone1
  • Phone2
  • Cell
  • Fax
  • WebSite
  • Email
  • Other1
  • Other2

Get Mail Labels

 This query will get the mailing addresses for letters that you need to print. This can be used to print your envelopes or labels.

Get Marked Accounts

This query will get the account information for the account(s) that you have 'Marked' on the Account Screen. This query also includes your company information as listed in the Get CompanyInfo query.

Account Fields:

  • AccountNumber  -  Your Assigned Account Number
  • Casenumber  -  Your Assigned Case Number
  • JC_Agreement_Name  -  This is the JC name(s) set on Account Screen (debt/exams/print tab)
  • JD_Agreement_Name  -  This is the JD name(s) set on Account Screen (debt/exams/print tab)
  • PNameLine1  -  This is the Judgment Style Plaintiff Name #1.
  • PNameLine2  -  This is the Judgment Style Plaintiff Name #2.
  • PNameLine3  -  This is the Judgment Style Plaintiff Name #3.
  • Plain1Address  -  This is the Judgment Style Plaintiff Address #1.
  • Plain2Address  -  This is the Judgment Style Plaintiff Address #2.
  • Plain3Address  -  This is the Judgment Style Plaintiff Address #3.
  • DNameLine1  -  This is the Judgment Style Defendant Name #1.
  • DNameLine2  -  This is the Judgment Style Defendant Name #2.
  • DNameLine3  -  This is the Judgment Style Defendant Name #3.
  • Def1Address  -  This is the Judgment Style Defendant Address #1.
  • Def2Address  -  This is the Judgment Style Defendant  Address #2.
  • Def3Address  -  This is the Judgment Style Defendant  Address #3.
  • Court  - 
  • CourtUpperCase  - 
  • CourtAddress  - 
  • County_Prefix  - 
  • County_Postfix  - 
  • County  - 
  • CountyUpperCase  - 
  • State  - 
  • StateUpperCase  - 
  • Amount  - 
  • AwardDate  - 
  • InterestDate  - 
  • APR  - 
  • CourtCost  - 
  • OJCFees  -  This is the TOTAL of Creditor Fees, Attorney Fees, and Pre-Judgment Interest
  • CreditorFees  -
  • AttorneyFees  -
  • PreJudgmentFees  -
  • Collected  - 
  • CourtOrderedPayment  - 
  • Remarks  - 
  • JC_Fee  - 
  • My_Fee  - 
  • Attorney  - 
  • AttorneyAddress  - 
  • AttorneyPhone  - 
  • UserDefined1 - 30  -  These are the 30 user defined fields on the account screen.

Creditor Fields:

  • C_PrimaryLastName  - 
  • C_PrimaryFirstName  - 
  • C_PrimaryMailname  - 
  • PrimaryMailname2  - 
  • C_PrimaryPhone1  - 
  • C_PrimaryPhone2  - 
  • C_PrimaryAddress1  - 
  • C_PrimaryAddress2  - 
  • C_PrimaryCity  - 
  • C_PrimaryState  - 
  • C_PrimaryZip  - 
  • C_PrimarySSN  - 
  • C_PrimaryDOB  - 
  • C_PrimaryEmail  - 
  • Website  - 

Debtor Fields:

  • D_LAST_NAME  - 
  • D_FIRST_NAME  - 
  • D_MAILNAME  - 
  • AKA  - 
  • D_ADDRESS  - 
  • D_CITY  - 
  • D_State  - 
  • D_Zip  - 
  • D_Phone1  - 
  • D_Phone2  - 
  • D_SSN  - 
  • D_DOB  - 
  • D_DL  - 
  • D_DL_STATE  - 

 Financial Fields:

  • CurrentPrincipal  -  Current Principal owed by debtor.
  • CurrentInterest  -  Current Interest owed by debtor.
  • CurrentRecoveryFees  -  Current Recovery Fees (expenses) owed by debtor.
  • CurrentOJCFees  -  Current OJC Fees owed by debtor.
  • CurrentCourtCosts  -  Current Court Costs owed by debtor.
  • CurrentBalance  -  Current Total account balance owed by debtor.
  • PerDiem  -  This is the daily interest amount that is applied to the account balance.
  • InterestStartDate  -  This is the date that interest is paid up to.
  • LastDate2  -  This is the last debtor payment date.
  • LastPayment2  -  This is the last debtor payment amount.
  • AppInterest2  -  This is the last debtor payment amount applied to Interest.
  • LastRebate2  -  This is the last debtor payment amount applied to Rebate.
  • LastRecoveryFees2  -  This is the last debtor payment amount applied to Recovery Fees (your expenses).
  • LastCreditorFees2  -  This is the last debtor payment amount applied to Creditor Fees.
  • LastCourtCosts2  -  This is the last debtor payment amount applied to Court Costs.
  • LastAPR2  -  This is the last interest rate set on the account.
  • GrossInterest  -  This is the gross amount of interest accrued on the account (requardless of what was paid)
  • InterestPaid2Date  -  This is the amount of interest paid on the account.
  • TotalPayments  -  This is the (gross) total amount of payments on the accounts.
  • TotalExpenses  -  This is the total amount of expenses on the account. This INCLUDES collection fees that are applied to collection accounts (line 1 of Expense Tab on Account Screen)
  • AdjustedTotalExpenses  -  This is the total amount of expenses on the account. This does NOT include collection fees.
  • CostsFeesExpenses  -  This is the total of Court Costs, OJC Fees, Recovery Fees. This INCLUDES collection fees that are applied to collection accounts (line 1 of Expense Tab on Account Screen)
  • AdjCostsFeesExpenses  -  This is the total of Court Costs, OJC Fees, Recovery Fees. Does NOT include collection fees.
  • CostsExpenses  -  This is the total Court Costs and Recovery Fees. Does not include OJC Fees. This INCLUDES collection fees that are applied to collection accounts (line 1 of Expense Tab on Account Screen)
  • AdjCostsExpenses  -  This is the total Court Costs and Recovery Fees. Does not include OJC Fees and does NOT include collection fees.
  • OwedCostsFeesExpenses  -  This is the amount still owed for Court Costs, OJC Fees, and Recovery Fees. This INCLUDES collection fees that are applied to collection accounts (line 1 of Expense Tab on Account Screen)
  • AdjOwedCostsFeesExpenses  -  This is the amount still owed for Court Costs, OJC Fees, and Recovery Fees. This does NOT include collection fees.
  • OwedCostsExpenses  -  This is the amount still owed for Court Costs and Recovery Fees. Does not include OJC Fees. This INCLUDES collection fees that are applied to collection accounts (line 1 of Expense Tab on Account Screen)
  • AdjOwedCostsExpenses  -  This is the amount still owed for Court Costs and Recovery Fees. Does not include OJC Fees. This does NOT include collection fees.
  • PaidCostsFeesExpenses  -  This is the amount paid towards Court Costs, OJC Fees, and Recovery Fees. This includes Collection Fees.
  • AdjPaidCostsFeesExpenses  -  This is the amount paid towards Court Costs, OJC Fees, and Recovery Fees. This does NOT include Collection Fees.
  • PaidCostsExpenses  -  This is the amount paid towards Court Costs and Recovery Fees. This does not include OJC Fees. This includes Collection Fees.
  • AdjPaidCostsExpenses  -  This is the amount paid towards Court Costs and Recovery Fees. This does not include OJC Fees. This does NOT include Collection Fees.

 

 

Get Marked Creditors

 This query will get the creditor information for creditors that you have 'Marked' on the Account Screen.

Get Marked Debtor Exams

This query will get the Debtor Exam information that you have 'Marked' on the Account Screen.

 Get Marked Debtors

This query will get the Debtor information for Debtors that you have 'Marked' on the Account Screen.

Get Marked Garnishments

 This query will get the Garnishment information that you 'Marked' on the Account Screen.

Get Other Addresses

This query will get your Other Addresses information from the Other Addresses Screen.

Get Verify Debtor Address

This query is used to print letters or post cards to verify your debtor's address.

 

 

Copyright 2010 - 2019, All Rights Reserved