WPS to make a personalized timetable

Every teacher's day is to receive many students ' holiday cards, each of which is full of children's love for teachers and respect for knowledge. Always want to return something, but suffer from a meager salary, but also afraid of exhaustive, hurt a young heart. This year teachers ' day, just bought a color inkjet printer, give each classmate to make a personalized curriculum as a holiday gift bar!

First, download the template.

I am not good at art decoration, from the WPS text home to pick a beautiful timetable it! Right, home "recommended" works in a good piece of work. Of course, we can also choose the right works in the category of "educational culture".

The work is opened as "Document 1" after double-clicking.

Second, fill in the course according to the actual situation, revise time.

Third, prepare personalized information.

Minimize the WPS text and create a new student info. ET on the desktop. Enter or paste the student's name, Zodiac, constellation, teacher impressions, blessings or other information of interest to the student.

Insert personalized data into the curriculum.

1, save and close the "student information. Et", will minimize the WPS document maximization. Enter "My Name", "My Sign", "My Horoscope", "Friend Impression", "Teacher parting".

2, click "Tools" → "Mail Merge Toolbar", the new toolbar appears.

3, open the data source. Click the first button in the Mail Merge toolbar to navigate to the student information. Xle Workbook and open it.

Select the worksheet that you want to determine.

4, Insert merge fields. Position the cursor after my name, click the Third button in the Mail Merge toolbar, pop up the dialog box, select the corresponding name of the student name (that is, the column heading in the ET table) and click the "Insert" button.

(effect after inserting a domain name)

5, the same way to insert other domain names to be merged.

6, preview the effect. Click the Fifth button in the Mail Merge toolbar to see the final effect.

7, print the finished product. Click the penultimate button in the toolbar to print out all the finished products.

When you merge to a printer as you would normally print a document, you can select "All" "current record" from ... To ... ", if you worry about making mistakes, you can try it first!

8, make up a dozen. If the paper is not carefully wrinkled, or sent to the students, the students want to have another copy, we can selectively print.

In the "View merge data" state, we can quickly find the one we need by using the positioning button in the toolbar (first record, previous record, next record, tail record) to print separately.

Interested friends can give it a try!