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

                                                                                                              • Attach file uploaded via Zoho forms into CRM

                                                                                                                Hi everyone, facing currently the problem that I like attach uploaded files from Zoho Forms into Zoho CRM. My approach was to use Zoho Flow but when using the Zoho Forms trigger, I receive the files in this structure: https://forms.zoho.eu/api/form/Testform/formperma/XXXXXXX/resthookdownload?filepath=/Testform/FileUpload1/12312312_Test_PDF.pdf
                                                                                                              • Adding Today's Date into an email template

                                                                                                                Is it possible to add today's date into an email template? Any help would be gratefully received.
                                                                                                              • Entry created or updated - not getting all fields

                                                                                                                I have a flow that fires on an entry being created or updated in a custom module in CRM.  It is only supposed to proceed if a particular field is false and once fired, immediately updates that field to true to avoid running multiple times.  For some reason,
                                                                                                              • Help createing Inventory Volume report

                                                                                                                I've been working with Zoho support for a few months now trying to develop a inventory volume report. Though they have been helpful, it never seems to generate exactly what we're looking for. I thought I'd turn to the community for further help. We've
                                                                                                              • Zoho Sprints - Timesheet Rejected

                                                                                                                Does a user get notified is his Timesheet entry has been rejected?
                                                                                                              • Sixth Insight - The Hidden C in Data

                                                                                                                The Wheels of Ticketing - Desk Stories The Hidden C in Data [Importance of clean data] Data cleaning Data cleaning ensures ticketing systems' data is accurate, consistent, and complete. This process includes eliminating duplicates, fixing errors, and
                                                                                                              • Simple Text Search Function

                                                                                                                Would it be too much to ask for a simple text search function? My slide decks are often simply collections of slides of a random over, and I often have to find the slide I need at a moment's notice. A text search function, no matter how rudimentary, would
                                                                                                              • KPI Widget would not load columns

                                                                                                                My Zoho Analytics would not load columns on KPI Widgets, is there anyone who could help me on this?
                                                                                                              • Introducing the calendar view for Bigin's Activities module

                                                                                                                Hello everyone, We're excited to announce the calendar view in Bigin. This view presents all tasks, events, and calls in an intuitive and visually appealing interface, and will be set as the Activities module's default landing page, ensuring you have
                                                                                                              • Add documents/uploaded files in Zoho CRM records that can be accessed by all team members?

                                                                                                                Hi, I'm building out our small business' Zoho CRM implementation and are on a Zoho One plan. We do LED Lighting Projects for customers, and collect data like customer utility bill PDFs, and pictures of existing lighting that we want to keep in one centralized
                                                                                                              • Customizing Helpcenter texts

                                                                                                                I’m customizing the Zoho Desk Help Center and I’d like to change the wording of the standard widgets – for example, the text in the “Submit Ticket” banner that appears in the footer, or other built-in widget labels and messages. So far, I haven’t found
                                                                                                              • Zoho Desk - I am no longer receiving email notifications when comments are made on tickets

                                                                                                                I still receive other notifications via email (e.g., new tickets and replies) - however beginning May21, I no longer receive notifications on comments (whether private or public) - I have confirmed that notifications are toggled on for agents within system/notification
                                                                                                              • Issues with Campaign Results Sync Between Zoho Campaigns and Zoho CRM

                                                                                                                Hi everyone, I’m experiencing an issue with the integration between Zoho Campaigns and Zoho CRM. When I send campaigns from Zoho Campaigns, the results shown in Campaigns (such as the number of emails sent, opened, and clicked) do not exactly match the
                                                                                                              • Greek languge

                                                                                                                Hello, Is there any support for Greek language in the near future?
                                                                                                              • Import records with lookup field ids

                                                                                                                Hi Is anyone able to import records into Recruit via spreadsheet / csv which contain ids as the lookup values. When importing from spreadsheet lookups will associate with the related records if using record name, however when using related records id
                                                                                                              • Custom module history is useless

                                                                                                                Hi I am evaluating ZOHO DESK as my support platform. As such I created a few custom modules for devices assigned to employees. I want to be able to see the whole picture when a device was reassigned to someone, but the history shows nothing Is there any
                                                                                                              • Email rejected per DMARC policy

                                                                                                                Hi, We've got the return message from zoho like 'host mx.zoho.com[204.141.33.44] said: 550 5.7.1 Email rejected per DMARC policy for circlecloudco.com in reply to end of DATA command' We're sure our source IP address matches the SPF the sender domain
                                                                                                              • How to import subform data - SOLUTION

                                                                                                                To all trying to import subform data, I might have a solution for you. First of all, for this solution to work, the subform data needs to be an independent form (not ad hoc created on the main form). Furthermore, this approach uses Excel sheets - it might not work using CSV/TSV. If this is true, then follow these steps: Import the subform records Then export these records once more including their ID Now prepare an import file for the main form that needs to contain the subform records Within this
                                                                                                              • Help center custom tab - link color

                                                                                                                I’m trying to add a custom tab to the main navigation in the Zoho Desk Help Center, for example to link to an external resource like a website. The problem is that any custom tab I add always shows up as a blue link – it doesn’t match the style of the
                                                                                                              • Organization API: code 403 "Crm_Implied_Api_Access" error for "https://www.zohoapis.com/crm/v2/org"

                                                                                                                Hello. I've developed an add-on that allows clients to synchronize data from Zoho CRM with the Google Spreadsheet. I am using the OAUTH2 protocol, so clients will have to authenticate into their Zoho account, and Zoho will send back to the app an access token which will be used to get data. Currently, there are about 100 clients, and everything works smoothly. Today I've found that a guy who could become a new client was not able to to get his organization data, because the application receiving
                                                                                                              • Pick list - Cannot save list "Special Characters not Allowed" error message

                                                                                                                Bulk uploading values. All values are pretty standard - with the exception of a "-" (dash). Like:  Industry - Prepared Food Is the simple dash a special character too? Jan
                                                                                                              • Zoho Projects API Error - API v3; Always HTTP 400

                                                                                                                Below I have uploaded my .py file I'm using: Always returns with response 400 :(( Console Logs: (venv) PS C:\Users\sreep\venv> python .\TimesheetBuddy.py Token file not found. * Serving Flask app 'TimesheetBuddy' * Debug mode: off WARNING: This is a development
                                                                                                              • Inquiry: Integrating In-house Chatbot with Zoho Desk for Live Agent Support

                                                                                                                Hi Team, We are exploring the possibility of integrating our existing in-house chatbot with Zoho Desk to provide seamless escalation to live agents. Our requirement is as follows: within our chatbot interface, we want to offer users a "Talk to Agent"
                                                                                                              • Introducing an option to set comments to public by default

                                                                                                                Hello all, Greetings! We are pleased to announce that Desk's user preferences now brings an option to set a comment type as Public or Private by default. In addition to setting reply buttons as defaults, Agents or Admins can now choose to make their ticket
                                                                                                              • Increase size of description editor when creating new ticket

                                                                                                                Please can you consider making the description editor in the create new ticket form a resizeable area as by default, it is very small and there appears to be no way to increase the size of it.
                                                                                                              • Flutter Plugin Compatibility Issue: Unresolved Reference to FlutterPluginRegistry in zohodesk_portal_apikit

                                                                                                                I am integrating the zohodesk_portal_apikit Flutter plugin (version 2.2.1) into my Flutter project, but I am encountering a build error related to an unresolved reference to FlutterPluginRegistry in the file ZDPBaseActivityAwarePlugin.kt. Below is the
                                                                                                              • I need my MFA number. I am trying to log into my CharmEhr. account and I can't get in. Everytime I try to sign in, it says to enter my MFA #. I don't have it.

                                                                                                                Need an MFA #
                                                                                                              • CRM Plus Accounts and Products relationships

                                                                                                                Is there a way that an invoice that is paid, would add the products to the account record once it is delivered? I want to find an easy way that products will get added to the account record and assumed this would work. The benefit here would be that I
                                                                                                              • "Super Admin Login as Another User" for Zoho One

                                                                                                                Dear Zoho One Team, We would like to request that the "Super Admin Login as Another User" feature be extended to Zoho One, allowing Super Admins to access user accounts across all Zoho One applications. We understand that this functionality is currently
                                                                                                              • Workflow for Creator App

                                                                                                                I am new to coding but doing pretty good with internet searching and ChatGPT but I have hit a major roadblock. What I am trying to do is have a sub-form populated with data from a form based on selected variables. I know this is possible because a guy
                                                                                                              • Subform dynamic fields on Edit, Load of Main form.

                                                                                                                Main Form: Time_Entry Sub Form (separate form): Time_Entries Time_Entries.Time_Entry_No is lookup to - Time_Entry.Time_Sheet_ID (auto number). I would like to disable some of the subform fields upon load (when edited) of the Time_Entry main form. What
                                                                                                              • Find all forms/fields containing a lookup field related to a specific form

                                                                                                                Hi, I'm trying to find all forms and the specific lookup fields they contain that are related to my Contacts form. I need to be able to do this programmatically (I know how to find this information using the schema builder). I've pulled the metadata for
                                                                                                              • Introducing the Eventbrite extension for Zoho CRM

                                                                                                                Hello Zoho CRM community, Are you struggling to keep your event registrations and attendance data organized across multiple platforms? Managing this information manually can be a frustrating and time-consuming task, and mistakes can easily occur, making
                                                                                                              • Deactivate Zoho CRM for everyone

                                                                                                                We would like to deactivate Zoho CRM for everyone. How can we do that?
                                                                                                              • Can I embed Zoho Project in Zoho CRM Record Detailed View

                                                                                                                Hello all, We use Zoho Projects a lot. The integration of Projects with Accounts and Deals only is great, but very limiting to our needs. Is it possible to either: add a project to related lists to custom modules - similar to how it is automatically added
                                                                                                              • COMPLAINT : Sleeping & Useless Support Team. GMail is better then..

                                                                                                                [## 118256452 ##] License upgrade issues: As a reseller, I tried to upgrade 1 license for my customer. It shown error. Raised complaints via Email/Chat/Phone support. Its been more than a week, still keep asking damn questions and comfirmations on once
                                                                                                              • Introducing the Reviews sub-module in Zoho Recruit

                                                                                                                Across every recruitment process, candidates are assessed by multiple stakeholders—recruiters, interviewers, hiring managers, and clients. These evaluations influence hiring decisions, yet they often exist in silos across assessments, emails, or interview
                                                                                                              • Unable to add a organization with US location

                                                                                                                I have created a Zoho Books trial account and since I am using Zoho People and payroll, Zoho Books has taken my existing credentials and created an Indian entity, but I am not able to add a US entity. How to add a US entity?
                                                                                                              • Two-Way Sync Zoho CRM Custom Module with Zoho FSM Company Addresses

                                                                                                                Business fact: Many companies don't just have one location. They have multiple locations (some have many), with addresses we need to know for service, deliveries, etc. We have created a custom "Sites" module in Zoho CRM to store an Account/Company's addresses
                                                                                                              • Meet the latest feature of Zoho Sheet: Lock Cells

                                                                                                                We are happy to announce the release of one of the most awaited features in Zoho Sheet. ​You can now lock the cells that you wish to keep ​secure. Once you are done with editing cells, you can lock them so that they won't be modified anymore. We believe that this feature will be a great addition to our existing set of collaboration features and is intended to improve your collaboration experience. You can access this new feature Lock from Data tab. Apart from being able to lock individual cell ranges,
                                                                                                              • Next Page