Hi,
I'm doing my first solicitation mailing since using Tessitura. I'm good with overall list, but really want to include the donor's last gift amount in my letter and response form, so therefore want it showing, I assume, in the output set (or extraction manager?)
This seems a standard type of requirement for a solicitation mailing...but I can't see in the list of options in the contributions heading of the output set any option for last gift. Love to hear from anyone out there who has done this for pointers in the right direction!
Cheers
Steff
Ok....WHERE do you run the script (I am not a coder...can you tell?)
Hey Stephanie,
Sorry for the delayed response here! I've been hosting my parents in town for the last week, so I've been away from the forums.
If you have access to the SSMS application when you log in to RAMP, you'll be running the script there for your database; you could just open that SQL file I shared in this thread and execute it, or copy-paste the code into the window and execute.
Thank you,
Brian