Letter Merge Tables

You can create tables to insert into some of your letters and emails. These tables contain fields that repeat. For example, for the Gift List letter, you can list all of the gifts that have been received during the time period selected. These gifts appear in a table in the letter.

The contents of each merge table depend on the letter template they are intended for. Not every letter template includes a table, and some letter templates allow you to select from several options.

You can change the columns in each table for your organization's needs. For example, you can add the gift reason, fund, or campaign name to the Gifts table that can be inserted into the Gift List template. See the Merge Table Setup topic for more detail on how to configure the tables.

The following letter templates include tables:

Letter Template

Merge Table

Contents

Acknowledgment Letter

Fund Splits

Fund name and amount for each fund included in the fund split for the gift.

Gift List

Gifts

Gift date, amount and value

Gift List

Gifts with Fund Name

Gift date, amount, value, fund names

Gift List

Gifts with Event Name

Gift date, amount, value, event

Pledge Reminder

Pledge Schedule

Pledge schedule amount, pledge schedule date

Tributes

Tributes

Names and addresses of donors who made a tribute gift

Volunteer Schedule Reminder

Volunteer Schedule

Scheduled date, start and end time, job

Volunteer Schedule Reminder

Volunteer Schedule with Project

Scheduled date, start and end time, project

Volunteer Schedule Reminder

Volunteer Schedule with Event

Scheduled date, start and end time, event

Volunteer Schedule Reminder

Volunteer Schedule with Task

Scheduled date, start and end time, task

Volunteer Thank You

Volunteer Hours

Scheduled date, start and end time, hours worked

Volunteer Thank You

Volunteer Hours with Project

Scheduled date, start and end time, hours worked, project

Volunteer Thank You

Volunteer Hours with Event

Scheduled date, start and end time, hours worked, event

Volunteer Thank You

Volunteer Hours with Task

Scheduled date, start and end time, hours worked, task

Grant Activity

Grant Activities

Activity scheduled date, activity type description

Grant Activity

Grant Activities with Summary

Activity scheduled date, activity type description, activity summary

Grant Payment

Grant Payments

Scheduled date, payment amount

Grant Payment

Grant Payments with Payment Type

Scheduled date, payment amount, payment type description

Guest Invoice

Guest Bill/Invoice

 

Guest Invoice

Guest Bill/Invoice with Charge Type