Merge templates generate customized documents by pulling data from your Grant Lifecycle Manager (GLM) or Scholarship Lifecycle Manager (SLM) site into pre-formatted Word documents. Templates can be used to create award letters, denial letters, envelopes, and other standardized communications that require personalized information for each recipient.
User Role: Administrator
Use Merge Templates to:
Generate customized award letters.
Create approval and denial letters.
Produce envelopes with applicant mailing information.
Build documents for a single request or multiple requests.
Build Merge Templates
A merge template starts as a document built in Microsoft Word or a similar program with your templated content (e.g. the award letter content). You then copy and paste merge fields into the template, using the Paste With Merge Formatting option in Word. Those merge fields tell the system what data you want to pull from your site into the template when generating merge documents with the template. In other words, the system merges data from your site into those fields.
In our award letter example, you might include merge fields for the applicant's name, the amount awarded, and the process name, so that information automatically populates in the letters.
Example Merge Templates
Several example merge templates including an approval letter, denial letter, and envelope are available in your Sandbox site. You can download any of these example templates and use them as a starting point for building your own merge templates. If you don't see these example templates available, reach out to Support.
Resources:
Generate Merge Documents
Once you've built a merge template and uploaded it to your site, you can use the template to generate merge documents. Merge documents can be generated for a single request and efficiently uploaded to the request. Merge documents can also be generated for multiple requests in a batch from the Requests & Decisions search page or a follow up workload page.
Resources: