Using WPS mail merge function to realize data batch insertion into document

In the past, when we wanted to print invitations, payrolls, and transcripts, we copied the texts in the form one by one into the doc file, which is obviously time consuming. , work efficiency is very low. So is there a better way to solve it? Of course, now use WPSOffice2012's mail merge feature, as long as a document template and a form of data. You can insert the data in the form into the document in batches! Let's take a look at how this is done. First, we have to prepare a grade bar template and a grade sheet. First open the grade bar template, select the "References" tab in the work bar above the WPS text, find the "Mail" button in the "References" tab and click. As shown in Figure 1, Figure 1 will pop up the "Mail Merge" tab and select the "Open Data Source" button. Select the prepared score sheet as the data source. As shown in Figure 2, in the "Mail Merge" tab, click the "Insert Merge Field" button, and select the corresponding name column in the field to insert into the table. Insert the corresponding data in the corresponding position. As shown in Figure 3, Figure 3 Figure 4 After the data is added, we can click on the "Merge Data" button to see the effect, as shown in Figure 5 Figure 5 Figure 6 Figure 7 Finally, in the "Merge Mail" tab Find the "Merge new document" button, merge the successfully inserted data into the new document and click "OK", you can! As shown in Figure 6.