Skillfully use WPS2012 Mail merge to insert data into transcripts

What do I do to print invitations, pay slips and transcripts? Are you still copying the text from the table to doc? Use the mail merge feature of WPS Office 2012, as long as you have a document template and a tabular data. You can insert the data in the form into the document in bulk! Let's take a look at how the details are done.

First of all, we have to prepare a score sheet and a score table. First open the Score bar template, select the Reference tab in the work bar above the WPS text, locate the Mail button on the References tab, and click. As shown in Figure 1

Figure 1

Click on 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

Figure 2 Computer Tutorials

Click the Insert Merge field button in the Mail Merge tab to insert a column name into the table in the field. Inserts the corresponding data in the corresponding position. As shown in Figure 3

Figure 3

Figure 4

After the data has been added, we can click on the "merge data" button to see the effect, as shown in Figure 5

Figure 5

Finally, find the "merge new Document" button on the "Merge Mail" tab and merge the successful data into the new document by clicking OK! As shown in Figure 6

Figure 6

Figure 7