Good Afternoon,


Please let em apologize in advance for my lack of programming and coding knowledge.


I am currently working on a Word Document that needs to be created "Dynamically". We have a "Master" document that has all of the paragraphs and phrases that could be used in the final version of the document.


My challenge is to add in logic that our 3rd party application (Conga Composer) can take and work with. There are Merge Fields throughout the document so that data from our CRM (Salesforce) flows into the document where needed.

I need to use several "IF" statements throughout the document because, depending on the "State" the recipient lives in (or some other criteria) will determine which paragraph from the Master document will be added or not. (A person living in CA would not need to see any information regarding state laws in South Carolina)


This is what my "IF" statement looks like right now (it's actually 4 different "IF" statements)


{ IF "{{OPPORTUNITY_AFFILIATE_ID}}" = 4418 "Payday Loan, LLC dba Payday Money Centers, with its headquarters at 300 S. Harbor Blvd., Suite 500, Anaheim, California 92805, California Finance Lender License No. 603 6712 (referred to herein as "Broker") is acting as a broker to assist LoanMe, Inc., 1900 S. State College Blvd., Suite 300, Anaheim, CA 92806, California Finance Lender License No. 603K061 ("Lender") in making your loan. By signing below, you acknowledge that you understand:
1. Broker is acting as a loan broker to help Lender make your loan. This assistance to Lender may include obtaining information and documents necessary for Lender to make your loan. 2. Broker will receive $300 from the Lender as compensation for brokering your loan.
2. Broker will receive $750 from the Lender as compensation for brokering your loan.
3. The terms and conditions of your loan are fully set forth in the following Promissory Note and Arbitration Agreement you will sign when the loan is made. You should read that loan agreement and all other documents carefully. You are under no obligation to make the loan if you do not wish to sign the loan documents." "" \* MERGEFORMAT }


The Yellow highlights indicate the field that the "IF" statement needs to reference. The Magenta highlights are so I can easily find the formula.
I have four (4) of these "IF" statements, one right after the next, as we have 4 different "Affiliate Id's", and each one has a different paragraph that needs to be displayed in the document.


Any help on this would be greatly appreciated.



Thank you,
Shawn