- In Mail, open an existing set of Donor Acknowledgement Letters or create a new one
- On the Fields to Include tab, Select per gift from the Send one letter to each donor: drop down and select the following fields:
- Gifts, Fund ID or Fund Description. Once selected, highlight it, click the Options button, and enter 2 as the Number of funds to export (or the total number of splits). Click OK.
- Gifts, Split Amount. A prompt automatically appears to enter the Number of Split Amount Fields to Export. Enter the same number as for Number of funds to export. In this example, enter 2.
- When setting up the merge document, both Fund and both Split Amount fields are available. Insert the fields into the document as normal if all gifts are split between the number of funds selected in step 2. If some gifts are not split and the Fund and Split Amount fields are included within a sentence (as opposed to a list), proceed to the following steps.
- This example creates a sentence like the following for gifts split between Fund A and Fund B: Thank you for your gift of $10 to Fund A and your gift of $20 to Fund B.
- In the merge document, place the cursor where the sentence should appear
- Enter Thank you for your gift of
- Press the Space bar and select Insert Raiser's Edge field, Split_Amount_1
- Press the Space bar and enter to the
- Press the Space bar and select Insert Raiser's Edge field, Fund_Description_1
- Leave the cursor where it is, immediately after the Fund_Description_1 merge field, and insert a conditional (If...Then...Else) statement:
- In the Field Name drop-down, select Split_Amount_2
- In the Comparison drop-down, select is blank
- In the Insert this text field, enter a period (.)
- In the Otherwise insert this text field, enter and your gift of AMOUNT to the FUND (Be sure to include a space before 'and' and a period after 'FUND.' 'AMOUNT' and 'FUND' are place holders.)
- Click OK
- In the merge document, display the field codes if you do not see the code for the conditional statement
- Delete the AMOUNT place holder and leave the cursor in its place
- Select Insert Raiser's Edge field, Split_Amount_2
- Delete the FUND place holder and leave the cursor in its place
- Select Insert Raiser's Edge field, Fund_Description_2
Thank you for your gift of { MERGEFIELD Split_Amount_1 } to the { MERGEFIELD Fund_description_1 }{ IF { MERGEFIELD Split_Amount_2 }= "" "." " and your gift of { MERGEFIELD Split_Amount_2 } to { MERGEFIELD Fund_description_2 }." }