Many people don’t know how to use WPS 2019 mail merge? The article brought to you today is about WPS If you still don’t know the relevant introduction about how to use mail merge in 2019, let’s learn it with the editor.

​ ​ 1. You need to use WPS before using the mail merge function Prepare two files in 2019: one is the template file of the grade notification (input fixed content in the WPS text according to the format of the grade notification and typeset it); two is the data source file (which is the file that stores student grades. It is recommended to use a WPS table file or EXCLE file storage).

​​ 2. Use WPS 2019 to open the score notification template file and click [Quote]-[Email].

3. Click [Open Data Source] in the opened [Mail Merge] menu.

​​ 4. Select the corresponding data source file in the pop-up dialog box and click [Open] below.

5. Click [Insert Merge Field] in the opened [Mail Merge] menu, and the pop-up dialog box will display all column headers in the data source.

6. Select the XXX that replaces the position in the template (if there is no XXX when creating the template, just position the cursor at the location where the content needs to be inserted), then select the corresponding column title in the dialog box and click Insert below (for example, if you need To insert the student's name, click the column header "Name" in the dialog box to insert). You can insert other column headers to the corresponding positions in the same way. Close the dialog box after all insertions are completed.

7. In the opened [Mail Merge] menu, click [Merge to New Document] or [Merge to Different New Document] (the difference lies in whether the result of the mail merge is to generate one document or each record to generate a separate document). In the pop-up Click [OK] in the dialog box, so that the merged result will generate a new document.

The above is all about how to use mail merge in WPS 2019. I hope it can be helpful to everyone!