WPS Table Batch Generation notice

The school will hold a lecture, inviting one or two-year parents to attend. The headmaster asked each parent to send a notice, for the solemn, request each notice has student name, in order to lighten the burden of class teacher, decided to use WPS Mail merge function directly generate files.

First, the new WPS document is as follows:

Cuturl ('

Notice

Parents of Students:

The new District Central Primary School Parent school is scheduled to hold a lecture in the school multifunctional classroom 8:30 April 24. The topic of this lecture is "How to develop a child's good habits". Keynote speaker for the central Primary school principals * * *. Please attend the lecture on time after receiving the notice.

Central Primary School of new zone

2011.4.22 ')

Second, the new WPS form is as follows:

Third, the mail merge.

1, open the data source.

Close the WPS form, open the notification document, click the first button in the Mail Merge toolbar, and select Open Data source.

2, Insert merge fields.

Before you move your cursor to the parent, click on the third button and select Insert Merge field.

Select the domain name you want to insert, the column heading, and click Insert.

The document changes as follows:

3, view the merged data.

Click on the fifth button to see the combined effect. Click on the toolbar "first record, previous record, next record, tail Record" button to easily see the parents will receive the notice.

4, merge to the printer.

Click on the penultimate button to appear in the following dialog box, you can print all the notification one by one. If a notice is lost or paper wrinkling can be selectively made up.

5, Save paper printing methods.

As the content of this notice is less, we can print more than one copy. Click the bottom Fourth button to merge all the alerts into the new document.

Now that all the notifications are separated by a section break into a single document in one page, we replace the section breaks with the paragraph marks in the form of find substitution.

With a little adjustment we can print two or three notices on one page.

6, other button introduction.

Second: Recipient button, you can selectively combine files to filter out the target recipients of this activity from existing tables.

Triple Recommendation: Click for free Download the latest version of WPS Office software "to see more computer tutorials

Sixth: Merge field shading, as the name suggests, you can add or remove shading to the merged area.

Third last: Merging to different new documents, you can make each student parent's notice a file.

Other button functions please experience, perhaps it is what you have been waiting for a long time, try it quickly!