Skillfully use WPS2012 Mail merge to insert data into transcripts

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.