Receipting mulitple gifts on one receipt

Have you considered generating a statement report instead of (or in addition to) a letter, listing all the gifts given on a particular date? At the beginning of the year, we generate Annual Statement Reports for our donors that make multiple gifts throughout the year, you could do something similar with a shorter date parameter.

Our donors very often split their gifts 2-4 ways.  With very few exceptions, I split the gifts in the single gift record for the day/check received.  Receipting is handled through the acknowledgement letters by including the initial unsplit amount to acknowledge that, then the split gift amounts and corresponding funds in the language in the letter:


"Thank you for your gift of <<Amount>>.  Per your request, we have designated your gift as such: <<Split_Amount_1>> to <<Fund_ID_1>>, <<Split_Amount_2>> to <<Fund_ID_2>>, <<Split_Amount_3>> to <<Fund_ID_3>>, <<Split_Amount_4>> to <<Fund_ID_4>>."


I then have a macro in Word that removes the extraneous language from those letters that are effectively blank/nonexistent splits (using wildcards, replace ",  to *." with ".").  If it's a single, unsplit gift I use a different letter.


If you want, here's the VB Macro code:

Public Sub BlankFundRemoval()

'

' BlankFundRemoval Macro

'

'

    Selection.Find.ClearFormatting

    Selection.Find.Replacement.ClearFormatting

    With Selection.Find

        .Text = ",  to *."

        .Replacement.Text = "."

        .Forward = True

        .Wrap = wdFindContinue

        .Format = False

        .MatchCase = False

        .MatchWholeWord = False

        .MatchWildcards = True

        .MatchSoundsLike = False

        .MatchAllWordForms = False

    End With

    Selection.Find.Execute Replace:=wdReplaceAll

End Sub