WPS 2005 How to batch production of employee information card

In practice, users may often need to edit a large number of formats that are consistent, with only a few different documents, such as reminders, employee payroll, and so on. If you use manual editing to print, although each document only needs to modify the individual data, but once the number of copies is more, this becomes a very distressed thing. So what can be done to reduce the tedious duplication of work and improve efficiency?

In fact, the WPS text added "Mail Merge" function, you can easily meet the needs of users.

Introduction to Mail Merge

What is "mail merge"? In terms of feature naming, mail merge appears to be related to mail, in fact, its role is in the mail document (main document) in the fixed content, through the database (or data table) in the integration of records, so that the bulk generation of the required mail documents, thus greatly improve the efficiency of the work, "mail merge" hence the name.

"Mail Merge" function is not only used in bulk processing letters, envelopes and other mail-related documents, has been widely used in bulk production of labels, payroll, transcripts and other applications.

The following is an example of "making an employee information card" to give users a brief introduction to how to use the mail merge feature.

Building a Database

First use the WPS table to create an "Employee Information table", after the completion of the worksheet as shown in Figure 1:

Figure 1 Employee Information Sheet

Note: The data table must have a header row (commonly called a "field" in the database), and the data range cannot have blank lines.

Create a main document

Start the WPS text, add the table using the Table tool, and create the "main document" for the employee information card, as shown in Figure 2:

Figure 2 Creating an information Card main document

Add Field fields

This example describes how to make 4 employee information cards in one page, with the following steps:

Step 1 Select the Tools | Mail Merge Tool menu item and bring up the Mail Merge toolbar, as shown in Figure 3.

Figure 3 "Mail Merge" toolbar

Step 2 Click the Open Data Source button on the Mail Merge toolbar and go to the Select Data Source dialog box, as shown in Figure 4.

Figure 4 "Select Data Source" dialog box

Step 3 Select the Employee Information table that you have established, click on the "Open" button and select "Employee Information table $" In the "Select Table" dialog box, as shown in Figure 5.

Figure 5 Selecting the specified data table in the open file-employee Information table