WPS Text Tutorial: Mail merge, one-click Print Invitation

The office of Xiao Liu will be married in the national day, can you use WPS text to print invitations? Not only can, but also can be done well.

★ Print the text to the specified position through "set".

★ Automatically extract VIP names from the WPS table by mail merge function.

One, set dozen

The so-called "set" refers to the printing of text to the invitation to the designated location, and we see in the Post office, the bank will print the same effect of the bill. How to use the WPS text to achieve this function?

1th Step: Scan Invitation inner core. Invitations are made up of exquisite coats and cores, as long as the text is printed to the core. To do this, the first thing we need to do is to scan the core with a scanner as a picture, as shown in Figure 1.

Figure 1

2nd step: Crop the picture. To run the WPS text, click insert → picture → from file to insert the picture into the WPS edit area. Next, select the picture and use the clipping function to remove the part except the inner core, as shown in Figure 2.

Figure 2

3rd Step: Set the picture size and alignment. The actual amount of inner core height, width is 192mm, 116mm respectively. To that end, right-click the picture that has been inserted into the WPS text and cropped, select Set Object format → size, clear the hook for the lock aspect ratio, relative to the original picture size, and then set the height and width to 192mm, 116mm respectively, as shown in Figure 3. Next, click Layout, select around, and then click Advanced, and under horizontal alignment, set alignment to left-aligned, to-relative to "set to Page", and under Vertical alignment, select alignment to top, and relative to page set to pages.

Figure 3

4th step: Set up the page. Click file → page setup, and under Margin, set the top, bottom, left, and right values to 0. Next, click Paper to set the width and height to 116mm, 192mm, respectively, as shown in Figure 4. When you are done, the picture will just fill up the entire page, as shown in Figure 5.

Figure 4

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

Figure 5

5th step: Insert text box. Insert multiple vertical text boxes and arrange them as shown in Figure 6. Note that in order to make the printed invitations look beautiful, set the font and font size of the text in the box. In which, the "submitted" text box is used to fill out the name of the VIP, we have arbitrarily entered a name, after the mail merge, the name will be replaced.

Figure 6

Step 7th: Combine text boxes. When a text box is selected, hold down the CTRL key on the keyboard and select the other text boxes one at a, until all is checked, right click, and select combination → group, as shown in Figure 7.

Figure 7

8th step: Delete the inner core picture. Delete the inner core picture. Next, right-click the grouped text box and select "Transparency" under "fill" to 100%, and select "Wireless stripe Color" under the line. The results will be as shown in Figure 8.

At this point, the "set dozen" settings are complete, save, set the filename "invitation template."

Figure 8

Ii. Mail Merge

Using the mail merge function of WPS text, we can extract the VIP names from the WPS table, and then print them to a specified position to achieve the "one-click" Printing of all the invitations.

Step 1th: Create a VIP roster. Run the WPS table, enter "name" on the first worksheet, the A1 cell in Sheet1, and then enter the VIP name in A2 and the cells below, as shown in Figure 9. After the completion of the save, set a document called "VIP roster."

Figure 9

2nd step: Select the data source. Open the invitation template file, click view → toolbars, and then select Mail Merge below. Next, click Open Data source on the Mail Merge toolbar, select the "VIP roster" of the WPS table file you have created, and then press the prompts to select the worksheet as "sheet1$," as shown in Figure 10.

Figure 10

3rd Step: Insert merge fields. Select "Ouyangyang ou", click "Insert Merge Field" (as shown in Figure 11), and select "name", when finished, the "Ouyangyang ou" will be replaced by a field named name.

Figure 11

4th step: Preview. When you click View Merged data, and then click the Forward or Back button, you can observe that the VIP name is displayed individually, as shown in Figure 12. Indicates that the mail merge has been fully effective.

Figure 12

5th step: "One key" printing. When you click the Merge to Printer button, you wait for a piece of paper to insert the invitation inside the printer until the VIP name in the VIP roster is printed!

Tip: This text operation is tested completely through the laser printer or inkjet printer. If you use a very original stylus printer, the text box will appear as a whole offset, please reset the page according to the actual situation to resolve.

Figure 13

In fact, the role of mail merge is still very large, such as the automatic printing of student notices, employee badges, etc., if there is such a need to try, it will make your office performance stand out.