Word 2010 Batch Processing report sheet

Teachers are going to start to fill out the Student report form, the number of students, a piece of manual fill is a very complicated thing to lock. In fact, use word "mail merge" function, let Word 2010 and Excel 2010 work together, can realize Achievement report single "Batch processing", save time and effort, finish the Student report form easily complete work.

　　I. Production of student performance statistics

Run Excel 2010, create a new worksheet named "Student Performance Table", and then enter the class, student name and various grades and other information into the form, and the "Student performance statistics table. xlsx" as the filename, save in the hard drive (Figure 1).

Fig. 1 Statistics of students ' achievements

Ii. drawing of a report on student achievement

Run Word 2010, click Page Layout, switch to the page layout ribbon, click the small arrow to the right of page setup, eject the Page Setup window, and set the page margins and paper size as needed (Figure 2).

Figure 2 Page Setup

Click the OK button to return to the Word 2010 editing window, drawing a student report sheet (Figure 3) and saving it as a "Student performance report Sheet", based on the relevant items in the "Student score. xlsx" table. docx.

Figure 3 Drawing the Student report form

Third, batch processing Student Achievement Report Form

Step One: Open the "Student report form" just set up. docx, click Mail, switch to the Mail ribbon, click Select Recipient, and select Use existing list in the pop-up drop-down menu (Figure 4), pop the Select Data Source window, and locate and select the Student performance tables. xlsx, click the Open button (Figure 5), and the Select Table window pops up, select Student Score $, and click OK (Figure 6).

Figure 4 Selecting recipients

Figure 5 Selecting a data source

Figure 6 Selecting a table

Step two: Return to the Word 2010 edit window, position the cursor where you want the data to be inserted, and then click the Insert Merge Field button, and click the option in the Drop-down menu to insert the data source one item into the corresponding position in the report sheet (Figure 7).

Figure 7 Inserting a data source

Step three: Click the "Complete mail Merge" button, select Edit Single document from the pop-up drop-down menu, pop the merge to New Document Small window, select all, current record, or specified range as appropriate, click OK (Figure 8) to complete the mail merge. The system automatically processes and generates each student's report form and lists them in the new document (Figure 9), and then you're done with the printer printing (Figure 10). (www.3lian.com)

Figure 8 Completing the mail merge

Figure 9 Batch Generation report form

Figure 10 Print performance report form

Tip: Click the "Complete mail Merge" button, select "Print Document" in the pop-up drop-down menu, you can print the report form directly, select "Send e-mail", you can send the batch-generated report form to the specified recipients by mail.