A method for bulk printing of forms and documents using the mail merge feature of WPS

A method for bulk printing of forms and documents using the mail merge feature of WPS

1, print Invitations: If not hand-written invitations, each invitation only guest name is different, a copy of open the document to fill, waste a lot of kung Fu.

2, the company Mail: Only the beginning of the recipient and part of the information is different, you will be a Feng Yi to send the change?

3. Transcripts and Payroll: for each student or employee to distribute transcripts and payroll, only a general form, how to make a formal report card to the students?

Below take the report card as an example, teaches everybody how batch output report card.

1, first open transcripts template. doc, click on the "References" tab and select "Mail", where the Mail Merge tab appears.

2, click "Open Data Source", select "Score table. xls", select the worksheet where the data resides. (to close the score sheet first. xls);

3, positioning the cursor in the template of the Learning Number column, click "Insert Merge Field", select the corresponding "School number" column in the table, and then click "Insert". Click "Cancel" to close the window, the location of the cursor will appear << number >> words.

4, click "View merged Data", you can see the effect of the merger, the Name column appeared students study number. Click "Next" to see the names of different students. Click "View merged Data" again to view the field codes.

5, according to the above method, respectively, the name, the results of each section into the corresponding position. And then look at the merge effect.

6, output and printing, and finally, if you want to generate a document for each student, click "Merge to different new document";

7, if you want to generate a document, which each page is a transcript of different students, you can click "merged into a new document", if you want to print out directly click "Merge to the printer."

Attention matters

If you want to send a message directly to each student, you can do so.

1, the score table. xls adds a list of "Student mailboxes" to fill in each student's mailbox.

2, click the "to", check the students to send in the mailbox.

3, the Computer Configuration good Outlook mail client.

4, click "Merge to E-mail" to send.