Mixing text to create Meeting Invitation with WPS Writer

WPS Office is a free office suite with many attractive features, providing users with 3 programs like the Microsoft Office suite : Writer, Spreadsheets and Presentation. In particular, WPS Writer is a text editor that supports most of the best text editing features today.

WPS Office 2019 Free

How to mix meeting invitations with WPS Writer

Mixing text is a useful feature in Word, but in this article Download.com.vn would like to introduce to readers how to mix text on WPS Writer, saving you time when writing documents. list format such as meeting invitations, certificates of merit, invitations ....

To perform text merging, you must first create a data file:

  • Original text file: Text containing document templates (* .doc format)
  • List file: Content is created as a list (usually create * .xls files)

In this article, the author will guide you to mix the text with the original document "Invitations to parents", we will have to create the following 2 files:

Shoes-hop.doc

List-new-hop.xls

Step 1: First, open up the original text file.

Mixing text to create Meeting Invitation with WPS Writer
Open Parent Invitations

Step 2: Then, click on the Reference tab , select Mail Merge.

Mixing text to create Meeting Invitation with WPS Writer
Select Mail Merge

Step 3: Immediately open the Mailings tab , click the Open Data Source option.

Mixing text to create Meeting Invitation with WPS Writer
Click Open Data Source to open the file

Step 4:  The Select Data Source window appears, open the file containing the meeting list (List-list-hop.xls), and then click Open.

Mixing text to create Meeting Invitation with WPS Writer
Select the Meeting invitation file

Step 5:  Put the cursor in the field you want to insert information, then click Insert Merge Field under the Mailings tab . When a dialog box appears, double-click the information field to be inserted (Here we select the Parent Name field ), and then click Insert> Close . Repeat this process for the next schools like Parents, School.

Mixing text to create Meeting Invitation with WPS Writer
Insert data from Excel file List of meeting invitations

Step 4: After the insert is complete, click on the View Merged Data icon to check the inserted data. You can use the First Record, Previous Record buttons on the toolbar to view the merged data one by one.

Mixing text to create Meeting Invitation with WPS Writer
View data after mixing

Step 5: Also want to extract data, you can select the function buttons on the toolbar in the Mailings tab as follows:

  • Merge to Different New Document: Extract each record into a separate file.
  • Merge to Printer: Extract each record to the printer.
  • Merge to New Document: Extract all records to the same file.
  • Merge to Email: Extract records sent by email.
Mixing text to create Meeting Invitation with WPS Writer
Select the form of data extraction

Video tutorial on mixing meeting invitations on WPS Writer

Sign up and earn $1000 a day ⋙

Leave a Comment

What is 1314?

What is 1314?

1314 is a number often used by young people as a love code. However, not everyone knows what 1314 is and what it means?

How to protect your mental and physical health when in a toxic environment

How to protect your mental and physical health when in a toxic environment

Dealing with toxic situations can be incredibly difficult. Here are some tips to help you handle toxic environments tactfully and maintain peace of mind.

Ways music stimulates the brain

Ways music stimulates the brain

Most people know that music is not just for entertainment but has many benefits. Here are some ways music stimulates our brain development.

The most commonly deficient nutrients in the diet

The most commonly deficient nutrients in the diet

Diet is important to our health. Yet most of our meals are lacking in these six important nutrients.

How to use Circle Ks CK Club app to receive attractive offers

How to use Circle Ks CK Club app to receive attractive offers

To get the fastest promotional information from Circle K, you should install the CK Club application. The application saves your payments when shopping or paying at Circle K as well as the number of stamps collected.

Instagram Will Allow Reels Up to 3 Minutes Long

Instagram Will Allow Reels Up to 3 Minutes Long

Instagram has just announced that it will allow users to post Reels videos up to 3 minutes long, double the previous 90-second limit.

How to view Chromebook CPU information

How to view Chromebook CPU information

This article will guide you how to view CPU information, check CPU speed directly on your Chromebook.

8 Cool Things You Can Do With an Old Android Tablet

8 Cool Things You Can Do With an Old Android Tablet

If you don't want to sell or give away your old tablet, you can use it in 5 ways: as a high-quality photo frame, music player, e-book & magazine reader, housework assistant, and as a secondary screen.

How to get beautiful nails quickly

How to get beautiful nails quickly

You want to have a beautiful, shiny, healthy nail quickly. The simple tips for beautiful nails below will be useful for you.

Color inspiration secrets only designers know

Color inspiration secrets only designers know

This article will list color-inspired tips, shared by top designers from the Creative Market community, so you can get the perfect color combination every time.

Everything you need to replace your laptop with a phone

Everything you need to replace your laptop with a phone

Can you really replace your laptop with your phone? Yes, but you'll need the right accessories to turn your phone into a laptop.

ChatGPT will soon be able to see everything happening on your screen

ChatGPT will soon be able to see everything happening on your screen

One important thing in the full event video was that the upcoming ChatGPT app feature was demoed but no real details were shared. That is, ChatGPT's ability to see everything that's happening on the user's device screen.

AI is learning to fool humans despite being trained to be honest

AI is learning to fool humans despite being trained to be honest

Many top AIs, despite being trained to be honest, learn to deceive through training and systematically induce users into false beliefs, a new study finds.

How to change questions on ChatGPT

How to change questions on ChatGPT

ChatGPT now has a question change option so users can edit the question or content they are exchanging with ChatGPT.

How to spot fake QR codes and keep your data safe

How to spot fake QR codes and keep your data safe

QR codes seem pretty harmless until you scan a bad one and get something nasty thrown at you. If you want to keep your phone and data safe, there are a few ways you can spot a fake QR code.