Use Mail Merge
Note: this option is available for paid versions only.
The Mail Merge feature is used to create a set of documents combining a common content which is taken from a text document and some individual components (variables, such as names, greetings etc.) taken from a spreadsheet (for example, a customer list). It can be useful if you need to create a lot of personalized letters and send them to recipients.
To start working with the Mail Merge feature,
Return to previous page
- Prepare a data source and load it to the main document
- A data source used for the mail merge must be an .xlsx spreadsheet stored on your portal. Open an existing spreadsheet or create a new one and make sure that it meets the following requirements.
The spreadsheet should have a header row with the column titles, as values in the first cell of each column will designate merge fields (i.e. variables that you can insert into the text). Each column should contain a set of actual values for a variable. Each row in the spreadsheet should correspond to a separate record (i.e. a set of values that belongs to a certain recipient). During the merge process, a copy of the main document will be created for each record and each merge field inserted into the main text will be replaced with an actual value from the corresponding column. If you are goung to send results by email, the spreadsheet must also include a column with the recipients' email addresses.
- Open an existing text document or create a new one. It must contain the main text which will be the same for each version of the merged document. Click the Mail Merge icon at the Home tab of the top toolbar.
- The Select Data Source window will open. It displays the list of all your .xlsx spreadsheets stored in the My Documents section. To navigate between other Documents module sections use the menu in the left part of the window. Select the file you need and click OK.
Once the data source is loaded, the Mail Merge setting tab will be available on the right sidebar.
- Verify or change the recipients list
- Click the Edit recipients list button on the top of the right sidebar to open the Mail Merge Recipients window, where the content of the selected data source is displayed.
- Here you can add new information, edit or delete the existing data, if necessary. To simplify working with data, you can use the icons on the top of the window:
- After all the necessary changes are made, click the Save & Exit button. To discard the changes, click the Close button.
- Insert merge fields and check the results
- Place the mouse cursor in the text of the main document where you want a merge field to be inserted, click the Insert Merge Field button at the right sidebar and select the necessary field from the list. The available fields correspond to the data in the first cell of each column of the selected data source. Add all the fields you need anywhere in the document.
- Turn on the Highlight merge fields switcher at the right sidebar to make the inserted fields more noticeable in the document text.
- Turn on the Preview results switcher at the right sidebar to view the document text with the merge fields replaced with actual values from the data source. Use the arrow buttons to preview versions of the merged document for each record.
- To delete an inserted field, disable the Preview results mode, select the field with the mouse and press the Delete key on the keyboard.
- To replace an inserted field, disable the Preview results mode, select the field with the mouse, click the Insert Merge Field button at the right sidebar and choose a new field from the list.
- Specify the merge parameters
- Select the merge type. You can start mass mailing or save the result as a file in the PDF or Docx format to be able to print or edit it later. Select the necessary option from the Merge to list:
- Choose the records you want to apply the merge to:
- All records (this option is selected by default) - to create merged documents for all records from the loaded data source
- Current record - to create a merged document for the record that is currently displayed
- From ... To - to create merged documents for a range of records (in this case you need to specify two values: the number of the first record and the last record in the desired range)
Note: the maximum allowed quantity of recipients is 100. If you have more than 100 recipients in your data source, please, perform the mail merge by stages: specify the values from 1 to 100, wait until the mail merge process is over, then repeat the operation specifying the values from 101 to N etc.
- Complete the merge