• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
TSB Alfresco Cobrand White tagline

Technology Services Group

  • Home
  • Products
    • Alfresco Enterprise Viewer
    • OpenContent Search
    • OpenContent Case
    • OpenContent Forms
    • OpenMigrate
    • OpenContent Web Services
    • OpenCapture
    • OpenOverlay
  • Solutions
    • Alfresco Content Accelerator for Claims Management
      • Claims Demo Series
    • Alfresco Content Accelerator for Policy & Procedure Management
      • Compliance Demo Series
    • OpenContent Accounts Payable
    • OpenContent Contract Management
    • OpenContent Batch Records
    • OpenContent Government
    • OpenContent Corporate Forms
    • OpenContent Construction Management
    • OpenContent Digital Archive
    • OpenContent Human Resources
    • OpenContent Patient Records
  • Platforms
    • Alfresco Consulting
      • Alfresco Case Study – Canadian Museum of Human Rights
      • Alfresco Case Study – New York Philharmonic
      • Alfresco Case Study – New York Property Insurance Underwriting Association
      • Alfresco Case Study – American Society for Clinical Pathology
      • Alfresco Case Study – American Association of Insurance Services
      • Alfresco Case Study – United Cerebral Palsy
    • HBase
    • DynamoDB
    • OpenText & Documentum Consulting
      • Upgrades – A Well Documented Approach
      • Life Science Solutions
        • Life Sciences Project Sampling
    • Veeva Consulting
    • Ephesoft
    • Workshare
  • Case Studies
    • White Papers
    • 11 Billion Document Migration
    • Learning Zone
    • Digital Asset Collection – Canadian Museum of Human Rights
    • Digital Archive and Retrieval – ASCP
    • Digital Archives – New York Philharmonic
    • Insurance Claim Processing – New York Property Insurance
    • Policy Forms Management with Machine Learning – AAIS
    • Liferay and Alfresco Portal – United Cerebral Palsy of Greater Chicago
  • About
    • Contact Us
  • Blog

Documentum and Alfresco – Automating Personalized Documents

You are here: Home / Product Suite / OpenContent Forms / Documentum and Alfresco – Automating Personalized Documents

August 9, 2018

In the past, many clients have generated personalized forms utilizing Adobe Forms as a template for an OpenContent Form (previously known as Active Wizard).  Recently, we’ve worked with an Insurance client to provide similar functionality using a Microsoft Word document with Mail Merge fields to produce personalized letters that can be sent out to clients.  This post will describe and demonstrate the new feature in the OpenContent Management Suite that allows word templates to be populated with data for consistent and automated creation of personalized documents.

OpenContent Forms provides a way for users to fill out forms using an intuitive wizard-based interface.  This wizard-approach simplifies the form filling process, especially for complex form scenarios.  Aside from simply filling out forms, this form data can be used to drive workflow review and approval processes, or in the case discussed here, create a document from a template.

OC Form Default Output

Typically, when filling out a form, the default output for the OpenContent Forms output is a fairly simple PDF file:

The default output utilizes this simple approach for one reason – when form configuration changes, there’s no corresponding change to the output template.  When questions and pages are added or removed from the form template, the output PDF simply flexes with the changes.

Utilizing Microsoft Word as a Template

As mentioned in our Adobe Form integration blog post, some clients need a more structured output.  Adobe forms work well for actual forms, but one client was more interested in generating letters.  For this client, we added the ability to utilize a Microsoft Word document with mail merge fields to drive the output.  Here’s what the template word document looks like.  Notice the mail merge fields that are placeholders for input data from an OpenContent Form:

 

After filling out the OC Form, the data entered into the form will populate the appropriate mail merge fields to generate the personalized letter.  Check out the video below to see it in action!

While our current client is utilizing the OC Forms integration with Word to generate letters, we see many other use cases where clients want additional control over the output PDF.  Currently, we support replacing text mail merge fields, but future iterations could support if fields as well to optionally include or exclude entire sections of the document – similar to how our HotDocs integration currently works.  Let us know your thoughts below.

Filed Under: OpenContent Forms, OpenContent Management Suite

Reader Interactions

Trackbacks

  1. OpenContent Management Suite – Fall 2018 Release — Technology Services Group says:
    January 22, 2020 at 11:49 am

    […] the data that the user enters into the form can be used to drive a Word document template.  Check out how this can be used to personalize documents.  Additionally, we also see this as an option to allow form data to drive contract generation when […]

    Reply

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Search

Related Posts

  • Alfresco No Code – Do More with OpenContent
  • OpenContent Management Suite – Fall 2018 Release
  • Document Review and Approval – Why Form AND Workflow are so important
  • Adobe Form Integration – Now Available from Active Wizard
  • Alfresco Claims Processing – Product Roadmap and Future Vision
  • Documentum and Alfresco – Salesforce Integration for Contract Management
  • Documentum – Top Tips for 2016
  • HotDocs – Document Creation for Documentum, Alfresco and Hadoop
  • TSG’s Top 10 list from the NIRMA 2015 Nuclear Records Conference
  • Documentum or Alfresco – HPI 2.3 Now Available for TSG Clients

Recent Posts

  • Alfresco Content Accelerator and Alfresco Enterprise Viewer – Improving User Collaboration Efficiency
  • Alfresco Content Accelerator – Document Notification Distribution Lists
  • Alfresco Webinar – Productivity Anywhere: How modern claim and policy document processing can help the new work-from-home normal succeed
  • Alfresco – Viewing Annotations on Versions
  • Alfresco Content Accelerator – Collaboration Enhancements
stacks-of-paper

11 BILLION DOCUMENT
BENCHMARK
OVERVIEW

Learn how TSG was able to leverage DynamoDB, S3, ElasticSearch & AWS to successfully migrate 11 Billion documents.

Download White Paper

Footer

Search

Contact

22 West Washington St
5th Floor
Chicago, IL 60602

inquiry@tsgrp.com

312.372.7777

Copyright © 2023 · Technology Services Group, Inc. · Log in

This website uses cookies to improve your experience. Please accept this site's cookies, but you can opt-out if you wish. Privacy Policy ACCEPT | Cookie settings
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT