How do you generate personalized certificates and save them in dynamic folders using Writer's mail merge?

How do you generate personalized certificates and save them in dynamic folders using Writer's mail merge?

Zoho Writer's mail merge feature can help you enhance the certificate management process. It's a great way to save time and effort!

Merge certificates and maintain a well-organised repository with personalised certificates stored in separate folders for improved tracking and reference and easier maintenance of data in participant records.

Here's how to merge certificates and neatly store them in dynamically organised folders:



Steps:
  1. Create a merge template or import the desired certificate template and customise it using the design and formatting options.
  2. Ensure you have collected the participant details in a data source and insert your data source into the template.
  3. Insert merge fields within the template to auto-fill participant-specific details.
  4. Under Choose Output, select Merge & save as individual files.
  5. Enter a name for the files.
  6. Choose Create new folder as the Location.
  7. Select a parent directory and click Dynamic folder creation.
  8. Designate merge fields as folder names and add nested folders if needed.
  9. Click Configure and save settings.
Give this feature a try and write to us at support@zohowriter.com or support@eu.zohowriter.com if you need further assistance.

You can also check out our knowledge base article on how to create and email certificates in bulk.

We'll be back with more updates. Stay tuned!

Until then,
Happy automating!

    Access your files securely from anywhere







                            Zoho Developer Community




                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                  • Ask the Experts



                                                            • Sticky Posts

                                                            • Zoho Writer's WordPress extensions

                                                              Hey Zoho Writer users! Say goodbye to all your WordPress content publishing woes with Zoho Writer's WordPress extensions. Publish content with all your formatting and images, republish content when you update a document, and more—from a single window
                                                            • Easily perform calculations using dates with the new DATEDIF function

                                                              Hey Zoho Writer users! We've enhanced Zoho Writer's formula capabilities with the new DATEDIF function. This allows you to calculate the difference between dates in days, months, and years. Function syntax: =DATEDIF(start_date, end_date, unit) Inputs:
                                                            • Date-based conditions and filters

                                                              Configure conditions with date  Hi everyone! We are excited to announce that you can now compare and filter data with date-based conditions. This update lets you compare date fields in a document to a reference date and display a text or value if the
                                                            • Introducing group by, aggregation, and repeating regions in mail merge templates

                                                              Display data exactly the way you want and highlight key insights with Zoho Writer's enhanced merge templates. We've supercharged Zoho Writer's merge templates with the capability to dynamically group, aggregate, and repeat data as blocks. You can now
                                                            • Say hello to an improved way to merge documents!

                                                              Automating all your documents from start to finish is now easier than ever with Writer's new merge tools.   If you haven't seen it yet, you can read the main announcement here. Here is the full list of the features we've rolled out: 1. Dynamic Table Headers


                                                            Manage your brands on social media



                                                                  Zoho TeamInbox Resources



                                                                      Zoho CRM Plus Resources

                                                                        Zoho Books Resources


                                                                          Zoho Subscriptions Resources

                                                                            Zoho Projects Resources


                                                                              Zoho Sprints Resources


                                                                                Qntrl Resources


                                                                                  Zoho Creator Resources



                                                                                      Zoho CRM Resources

                                                                                      • CRM Community Learning Series

                                                                                        CRM Community Learning Series


                                                                                      • Kaizen

                                                                                        Kaizen

                                                                                      • Functions

                                                                                        Functions

                                                                                      • Meetups

                                                                                        Meetups

                                                                                      • Kbase

                                                                                        Kbase

                                                                                      • Resources

                                                                                        Resources

                                                                                      • Digest

                                                                                        Digest

                                                                                      • CRM Marketplace

                                                                                        CRM Marketplace

                                                                                      • MVP Corner

                                                                                        MVP Corner







                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now


                                                                                            Zoho Show Resources

                                                                                              Zoho Writer

                                                                                              Get Started. Write Away!

                                                                                              Writer is a powerful online word processor, designed for collaborative work.

                                                                                                Zoho CRM コンテンツ



                                                                                                  Nederlandse Hulpbronnen


                                                                                                      ご検討中の方




                                                                                                              • Recent Topics

                                                                                                              • Adding additional fields for batch information

                                                                                                                Hello, I am looking at adding additional information into our inventory module. we would like to be able to see up to 8 attributes that will be individual & different for each batch (i.e. batch specific information) but currently I seem to only be able
                                                                                                              • Dynamic Pickup List Values using Deluge and Client Script

                                                                                                                I would like to dynamically show Pickup List Values For example we need to fetch some data from an on premise application and display it so they can choose and pick This can be done in Creator but I didn't find anything for CRM
                                                                                                              • Validation Rule for Controlled Stage Movement in Deals Module (Deluge Script)

                                                                                                                For keeping a control over module stage or status, you can use the below deluge script. The below deluge script defines validation control over deals module stages: // Function to validate allowed stage transitions in the Deals module map validation_rule.LeadStatustValidation1(String
                                                                                                              • Pick List Issues

                                                                                                                I have created a pick list that looks at a table in a sheet, it selects the column I want fine. Various issues have come along. The option to sort the pick list is simplistic, only allows an ascending alphabetical sort. Bad luck if you want it descending.
                                                                                                              • Four types of task dependencies

                                                                                                                "Nothing is particularly hard if you divide it into small jobs."                                                                                                                  - Henry Ford Projects, small or large, are driven by simple work units called tasks. Monitoring standalone tasks might look simple but as the workflow becomes elaborate, tasks may start relying on one another. In project management, this relationship between tasks is termed as "Task Dependencies". Dependency between tasks arise
                                                                                                              • 1099 tracking

                                                                                                                Do zoho books offer feature of tracking for 1099's for contractors, etc? Quick books offers this feature and wondered when/if Zoho books will do same
                                                                                                              • VAT-type Taxes in US Edition?

                                                                                                                I'm located in the US, and I use the Zoho One US edition of Books. We are in the process of registering with Canadian authorities for their GST / HST, which is a VAT-type of scheme. It is not immediately obvious to me how one would deal with input tax
                                                                                                              • Schedule sms to be sent later

                                                                                                                When will you make available an option to send sms's at a later time??? You finaly have this option available on emails, so it will be very useful to have it also with sms. Our sms provider, has already this available but we cannot use it because you
                                                                                                              • Ecommerce integration with prestashop

                                                                                                                Development of campaigns integration with prestahop. When???
                                                                                                              • How to create an article containing images and rich text via the api?

                                                                                                                Hi, I'm trying to migrate our kb articles from our previous helpdesk service, and import them to ZohoDesk. Is there any way to create an article that contains images?  Is it possible to add formatting to articles created via the API? Thanks, Adam.
                                                                                                              • Number of statement execution limit exceeded on deluge scheduled function

                                                                                                                I'm working on a send email functionality in creator that sends out crew work orders at the end of the day each day for the next day. I'm running into the issue that zoho is unable to handle the number of statements that I am doing to be able to successfully
                                                                                                              • Zoho SignForm In Progress But Cannot Be Completed

                                                                                                                If a person starts signing a document (via SignForm), but closes the window before submitting, Zoho marks the document "in progress", but how do they finish signing it?
                                                                                                              • How to show Assemblies AND component items in a report

                                                                                                                Hi Is there any way in Analytics to create a report that shows the Composite Item AND the Component Items with mapped quantity? It seems that the component item is not exposed in any table that I can find. Also, the same question but for Stock on Hand.....this
                                                                                                              • Mandatory Messages for Specific Members in Zoho Cliq Channels

                                                                                                                Hello Zoho Cliq Team, We hope you're doing well. We would like to request a feature enhancement to Zoho Cliq that would allow marking certain messages in a channel as mandatory for specific members — with built-in tracking and reminders. 🎯 Use Case:
                                                                                                              • Admin Access to Message Read Statistics in Zoho Cliq

                                                                                                                Hello Zoho Cliq Team, We hope you're doing well. We would like to request a feature enhancement that would allow admins or channel owners to view read/unread statistics for messages, even if they were not the original sender. 🎯 Use Case: Currently, in
                                                                                                              • Online Member Visibility in Channels (Similar to WhatsApp Group Presence)

                                                                                                                Hello Zoho Cliq Team, We hope you're doing well. We’d like to request an enhancement to Zoho Cliq’s channel experience by introducing online presence indicators for channel members — similar to how WhatsApp shows how many people in a group are currently
                                                                                                              • Show ticket field in Zoho Desk only if that same field is not empty (API‑created records)

                                                                                                                Zoho Team , We have a ticket workflow where every ticket is created via API based on dynamic logic from an external form. That form has complex logic and already decides what’s relevant to ask, and the API only populates fields in Zoho Desk based on that
                                                                                                              • Multiple Products on Ticket

                                                                                                                Good morning. We will classify all tickets based on the product. Users sometimes send different requests on the same ticket, so we are facing some challenges. Is there a way to add more than one product to the ticket, or is there a way to tie the product
                                                                                                              • Não recebo Email de confirmação e validação de cadastro do PagSeguro

                                                                                                                Olá, utilizei uma das minhas contas de email Zoho para criar um cadastro no PagSeguro, contigo o email com o link de confirmação da conta não chega no meu email Zoho (nem.ma caixa de spam, nem na lixeira, e nem em outras pastas). Outros emails do PagSeguro
                                                                                                              • accounts payable and receivable subaccounts

                                                                                                                How to create accounts payable and receivable subaccounts? Being that I have several clients and in my balance sheet have to specify the accounts of each client and not only appear "accounts receivable or accounts payable" ??
                                                                                                              • DUPLICATING WORKFLOWS IN CREATOR

                                                                                                                Hi all, I want to duplicate and slightly amend 3 workflows in Creator so that I don't have to keep typing in all the rules and properties each time. I can see lots of videos on CRM with the 3 dots at the top of the workflow, but nothing like that in Creator.
                                                                                                              • Add SKU to query options in `items` API endpoint

                                                                                                                It would be very useful to be able to pull items by SKU in the API as this is a commonly used unique ID that tends to be consistent across systems.
                                                                                                              • Estimates and invoices being sent from company-wide address, rather than individual

                                                                                                                In our organization, team members send estimates and invoices through Zoho Books by using the "Send Email" function. However, for certain users, the system defaults to sending estimates and invoices from a shared organizational email address (e.g., company@example.com)
                                                                                                              • Need profit margins for books in estimates & invoice

                                                                                                                https://help.zoho.com/portal/en/community/topic/show-my-cost-or-profit-while-creating-estimate
                                                                                                              • Decimal places settings for exchange rates

                                                                                                                Hello, We are facing issues while matching vendor payments with banking feeds. As we often import products/services exchange rate comes into play. Currently, ZOHO allows only six digits for decimal places. We feel that conversions like JPY to INR require
                                                                                                              • Item Level Notifications

                                                                                                                I need to create a custom workflow based on the creation of an estimate that has a SKU/Item name that matches certain criteria. I can have it generated based on a total amount, but not at the item level. Is this possible?
                                                                                                              • Cannot categorize a bank deposit to an income sub-account

                                                                                                                When I go to categorize a bank deposit, I am not able to see any income sub-accounts. If I set up an income account without a parent, then I am able to categorize a transaction into that account, but as soon as I make it a child account, it disappears
                                                                                                              • ZV Extension passkey changes in v5.7.0

                                                                                                                Has there any changes to the how passkeys are managed in ZV - Chrome extensions v5.7.0? Namely, if the passkeys were already implemented/enforced as 2FA on a certain webpage, but ZV does not track them yet. Would that be the issue for my use case?
                                                                                                              • What's New in Zoho Billing - August 2025

                                                                                                                Hello everyone, We are excited to share the latest updates and enhancements made to Zoho Billing in August 2025 to improve your overall billing management experience. Keep reading to learn more. Notify Customers About Subscriptions via WhatsApp Business
                                                                                                              • How do I get my account id?

                                                                                                                Hello, I followed the instructions to get a list of accounts of the currently authenticated user (which is me, and I am logged in). But when I follow the below instructions I get the following error: ERROR: {"data":{"errorCode":"INVALID_TICKET","moreInfo":"Invalid ticket"},"status":{"code":400,"description":"Invalid Input"}} Instructions that I am following: GET - User account details Purpose The API retrieves the list of accounts of the currently authenticated user.  Request URL  http://mail.zoho.com/api/accounts
                                                                                                              • Why are tasks not showing in Zoho Calendar?

                                                                                                                Hi there, I updated the Zoho calendar preferences for Task records to show on the calendar together with Meetings and Calls - see attached screenshot. Despite of that, Task records still won't show on the calendar. Is there a specific reason why this
                                                                                                              • Zoho Payroll: Product Updates - July 2025

                                                                                                                Over the past month, we've focused on making Zoho Payroll more flexible, compliant, and easier to use—whether you're processing complex payouts, ensuring accurate calculations, or meeting local tax regulations. Here's what's new: One-Time Payments and
                                                                                                              • Discussion for “sub product”, “sub item” or “child products”

                                                                                                                Hello everyone, In some CRM systems, there is the ability to associate products in a hierarchical manner within a quote. For example: Product A: Gold Plan Product B: Setup Product C: Connector Product D: Silver Plan Product B: Setup Product C: Connector
                                                                                                              • Retrieve Accidental Deleted User

                                                                                                                Is there a way to undelete a user who accidentally deleted themselves?
                                                                                                              • Request for Support - CRM Integration Issues

                                                                                                                I’m reaching out to request assistance with the following items: 1. Zoho Forms Integration with Zoho CRM We are currently using Zoho Forms to send the Global Credit Application form to our customers. The intended workflow is for the form submissions to
                                                                                                              • Knowledge Base Module

                                                                                                                How to enable the knowledge base module in zoho crm account. I saw this module in one crm account but unable to find it other zoho crm account. can anyone know about this?
                                                                                                              • Zoho sign changed Indexing of signing_order

                                                                                                                Because I missed this Announcement (is there even one?): when you work with the indexes of actions > signing_order. Previous those started with 0 now starts with 1. Changed somewhere between 15.07 and 23.07
                                                                                                              • How to Invoice Based on Timesheet Hours Logged on a Zoho FSM Work Order

                                                                                                                Hi everyone, We’re working on optimizing our invoicing process in Zoho FSM, and we’ve run into a bit of a roadblock. Here’s our goal: We want to invoice based on the actual number of hours logged by our technicians on a job, specifically using the timesheets
                                                                                                              • Zoho CRM Community Digest - June 2025 | Part 2

                                                                                                                Welcome back to the Zoho CRM Community Digest! We’re wrapping up June with more fresh updates, smart discussions, and clever workarounds shared by the community. Product Updates: Struggling to keep track of scattered customer interactions? Zoho CRM's
                                                                                                              • Allow Variable Insertion in Prebuilt "Update Record" Action in Schedules

                                                                                                                Hi Zoho Creator Team, Hope you're doing well. We’d like to submit a feature request based on our experience using Zoho Creator schedules to manage workflows integrated with Zoho Desk. We currently have an app where Zoho Desk tickets create records in
                                                                                                              • Next Page