Label Templates in Writer

Working with Label Templates

How to merge and print labels?

Mailing labels are commonly used in letters and packages to identify the addressee and the sender information. These labels are used for various business purposes, such as sending a monthly billing statement to your customers, sending Greeting Cards during Christmas & New Year, or a direct mailer campaign about the newly launched customer referral program. In all these cases, you have to either manually type the mailing addresses on a blank page or use a different software to fetch addresses from your customer database, insert addresses in a word processor and then use a good quality printer to print the labels.
To deal with such cases, Writer comes with built-in templates to create labels. From shipping labels to Avery-compatible layouts, we've got most of your needs covered. You can print a single or a sheet of labels based on your requirements.

Let's take a look at the steps below:

Step 1: Choose/Create a label template

Labels come in different sizes and are used for different purposes. You can create a new printing label template from scratch or choose a default template available in your Writer account. Also, import label templates from Avery or Office 365.

To choose a, existing label template from the template library,

  1. Click File > New from Template.
  2. Under Templates header, choose Labels and Envelopes.
  3. Choose a template that suits your needs or import one from Avery or Office365 templates.

Step 2: Select data source

You need to create or upload a data source file (csv or a spreadsheet file) to merge the values with the mailing label. The data source is usually a spreadsheet or a comma-delimited (.csv file), which includes fields and records that have to be merged with the target document.

Configure the data source that has the information to be merged in your label template, such as, the name and address of each recipient to be printed on the labels.

To create or import a data source,

  1. Click More > Automate > Merge template.
  2. Choose your data source from the Merge Template panel. Choose Import CSV from Desktop or URL to pull data from a spreadsheet file.
  3. If you have the data in a Zoho Sheet file, then select Zoho Sheet as your data source.
  4. Click Create new data source to create a new data source from scratch and merge with the label. This will open an empty Zoho Sheet file in a new tab. Start entering the required data and sync it with your target label template.

Step 3: Insert merge fields

Once the data source is synced in your label template, you need to set up the template with the required merge fields.

  1. Click More > Automate > Merge template.
  2. Under Insert Fields header, you will find the available merge fields to be inserted in your document.
  3. Now insert merge fields in your label. Each row (or record) in your data source will be merged with an individual label.
  4. Once the above output configurations are done, click the Save Settings button. The label merge template will be saved.
Use the Next Record field to jump over to the next row in your data source.

Step 4: Preview document

Before you download or print the final document, you can preview the document and make changes, if needed.

  1. Click Preview Merge under the Preview Document header.
  2. Check if the labels are ready to print in the Preview mode. You can Print/Download/Email right away from the preview merge page.
  3. Click the Back to Editor button if you need to make any change to your label template.

    Zoho CRM Training Programs

    Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

    Zoho CRM Training
      Redefine the way you work
      with Zoho Workplace

        Zoho DataPrep Personalized Demo

        If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

        Zoho CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now

            Get started with Zoho Sign

            in a few quick steps!

            Download Help Guide

                      Still can't find what you're looking for?

                      Write to us:



                          Zoho Marketing Automation

                            Zoho Sheet Resources


                                Zoho Forms Resources

                                  Secure your business
                                  communication with Zoho Mail

                                  Mail on the move with
                                  Zoho Mail mobile application

                                    Stay on top of your schedule
                                    at all times

                                    Carry your calendar with you
                                    Anytime, anywhere

                                          Zoho Sign Resources

                                            Sign, Paperless!

                                            Sign and send business documents on the go!

                                            Get Started Now

                                                Zoho SalesIQ Resources

                                                    Zoho TeamInbox Resources

                                                            Zoho DataPrep Resources

                                                              Zoho DataPrep Demo

                                                              Get a personalized demo or POC

                                                              REGISTER NOW

                                                                Design. Discuss. Deliver.

                                                                Create visually engaging stories with Zoho Show.

                                                                Get Started Now

                                                                                      • Related Articles

                                                                                      • How to merge Writer templates using Zoho Flow?

                                                                                        We're working on a Zoho Flow-Writer integration to help you pick template documents from Writer, place merge fields on them and merge it with data from Zoho Services. Find below steps to merge Writer Documents and with Zoho Creator Form fields. ...
                                                                                      • Where can I find pre-built document templates in Writer?

                                                                                        Writer is in-built with 100+ templates from letters, cards, brochures, resumes, and much more. You fill find Writer template gallery here Templates are available on the right panel of the Writer dashboard as shown below.  For more details, ...
                                                                                      • Working with Templates

                                                                                        Templates  are preset layouts that make it easy to create and shape different types of documents. Templates help you adhere to standard document styles, ensuring professionalism and consistency across your organization, and reducing the amount of ...
                                                                                      • How to sign writer documents with Zoho Sign?

                                                                                        Zoho Sign integration in Writer allows you to draft business contracts, NDA's, sales agreement, lease agreement, etc., and send it out for signatures directly from within Writer.  Templates will remember the exact placement and type of the signature ...
                                                                                      • Working with Fields

                                                                                        Supported field types Supported field types Description Possible Values in the data source Rendered as Notes Plain Text The value of the field is placed as a string in the document. “test” “test” You can select the field in the document and apply the ...
                                                                                      Wherever you are is as good as
                                                                                      your workplace



                                                                                        Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.


                                                                                        Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.


                                                                                        Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.

                                                                                        CRM Tips

                                                                                        Make the most of Zoho CRM with these useful tips.

                                                                                          Zoho Show Resources