Merge using existing data - Setup Fields
Table of Contents
Writer's Document Merge lets you pull data from different data sources such as a CSV file, Zoho sheet, Zoho Contacts, Zoho CRM, and Zoho Forms. Usually, when you select your data source file, a list of data field names will appear in the Merge Existing Data panel. For example, <<Name>>, <<Company>>, <<Email>>, etc,. Before you get started, you need to setup the field name and the respective data in your data source file, which will be merged with your target document.
Field names represent the column header names of your data source file. A .csv or a spreadsheet file can include field names such as «FIRSTNAME», «LASTNAME», «EMAIL» etc,. You can also include hyperlinks and image fields in your data source and use in your target document. Let's discuss in detail on how you can setup different fields for Mail Merge.
You can include hyperlinks in your data source (a spreadsheet or .csv file) that needed to be linked in the merged document. Say for example, you're sending a welcome letter to your new recruits and you require sending a link to their respective profiles to each individual personally. All you need to do is, insert the respective link for each record in your data source file.
Writer allows adding custom image fields in your data source that will be directly linked as an image file in your target document. This allows different images to appear on each merged record of the final shipment.
To merge pictures into your documents or pages,
- Open your data source file and include the path of the image files to respective records.
- The image will be embedded in your target document and will be sent to the respective email recipients.
- You cannot include or paste the actual images in your data source.
- The image should be a publicly hosted link and you can provide that as a record in your data source (.csv or Zoho Sheet). Copy the exact image URL and add it as a record in your data source.
To fetch data from multiple records you can make use of the Next Record option in the Mail Merge feature. Say for example, you're creating a letter or an email to all your customers and you require to say different things in your mail depending on the different values in the fields of your data source. Once you have inserted a mail merge field select Next Record option and then either copy paste the same field or insert a new field. So that the field which you have inserted before Next record will fetch data from the first record and the field inserted after Next Record will fetch data from the next corresponding record.In short, Next Record field will let you jump over to the next row in your data source. This is especially useful while working on labels or documents with multiple identical fields.
- Open your document.
- Click More > Automate > Document Merge > Merge Existing Data.
- In the Merge Existing Data panel, select your data source and sync it inside Writer.
- Now in Insert Fields panel, click on <<Next Record>> button to insert it anywhere in your document.
While using Writer’s document merge feature, you can also include special fields that allows you to insert conditions. Using these conditional fields you can control how the data is shown to the end user.
When you're creating a letter or an email template to send your recipients and you want the letter to display different things depending on the different field values of your data source, you can insert conditions.
Let's see how you can do this.
Once you have set the data source and merge fields, you can insert conditions to the field values.
To insert a conditional field,
- Open the required template.
- In the Merge Existing Data panel, click on the Insert Conditions links under the Insert Fields header.
- Specify the conditions based on your requirements in Set Conditions popup.
- You can also insert multiple conditions. To define multiple conditional fields, click on the + icon in the Set Conditions popup.
- Click Apply to insert the conditional field in your template.
You can edit the conditional fields that are already inserted in your document. Simply click on the if-condition part and the Conditions pop-up will appear. You can edit and update the changes to the conditional fields. Also, you can simply mouse hover on the condition to just view it.