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

How to use Gemini AI as a virtual assistant on Android instead of Google Assistant

How to use Gemini AI as a virtual assistant on Android instead of Google Assistant

Android users can now use Gemini instead of Google Assistant to use more advanced features on Gemini virtual assistant.

How to chat with Google Gemini using images

How to chat with Google Gemini using images

Gemini now allows you to chat with images, search information from images on Gemini. Gemini will analyze the image you upload and from there give you the information you want to find.

How to edit images on Copilot AI

How to edit images on Copilot AI

Users can now edit those images right in Copilot without having to use additional image editing software.

Instructions for removing table formatting in Excel

Instructions for removing table formatting in Excel

When you download an Excel file from the internet, the table format may not match your data table creation requirements. If so, you can remove the table format in Excel.

5 Ways to Fix Apple Watch Not Pairing Error

5 Ways to Fix Apple Watch Not Pairing Error

While Apple Watch is a great way to track your daily fitness, send messages, and more, what happens if your Apple Watch won't pair?

The 6 Oldest Companies in the World Still Operating, Number 1 Has Been Operating for 1,400 Years

The 6 Oldest Companies in the World Still Operating, Number 1 Has Been Operating for 1,400 Years

What is the oldest company in the world? When was the oldest company in the world founded? Let's find out together!

How to review deleted notifications on Samsung

How to review deleted notifications on Samsung

In the new One UI 3.0 version on Samsung, users can use many other interesting and attractive features, such as reviewing deleted notifications on the Samsung status bar.

International Mens Day wishes, November 19 wishes for boyfriend, lover, husband sweet and romantic

International Mens Day wishes, November 19 wishes for boyfriend, lover, husband sweet and romantic

What are the best and shortest November 19 wishes for your lover? If you are out of ideas, this article will suggest meaningful November 19 wishes for you.

How to wear a sweater stylishly and comfortably

How to wear a sweater stylishly and comfortably

Basic sweaters are an indispensable part of all of our fall and winter wardrobes. Here are some simple yet fashionable ways to mix and match sweaters.

The easiest way to turn enemies into friends

The easiest way to turn enemies into friends

Having enemies is always an unpleasant situation. Luckily, you can turn your enemies into friends. Here are some simple ways to mend relationships that are available to everyone.

How many people can use one Netflix account at the same time?

How many people can use one Netflix account at the same time?

Since Netflix is ​​easily accessible on all devices including phones, tablets, game consoles, and streaming devices, you might be wondering how many people can watch Netflix at the same time on the same account.

Ways to center cells in a table on Word

Ways to center cells in a table on Word

Centering cells in Word when working with tables is an operation that needs to be performed to reformat the text in each cell according to regulations, as well as create a Word table with a more beautiful and easy-to-see layout.

Samsung partners with OpenAI to develop AI TV, promising many interesting features

Samsung partners with OpenAI to develop AI TV, promising many interesting features

Samsung Electronics is reportedly collaborating with OpenAI on an ambitious joint project to develop AI TVs that incorporate industry-leading artificial intelligence technologies.

Minecraft 1.21 update has an official release date

Minecraft 1.21 update has an official release date

After a lot of snapshots, additions, and changes, the update is complete and ready for release. The official Minecraft 1.21 release date has just been revealed!

Feast your eyes on the performance of Chinas skillfully dancing Robot

Feast your eyes on the performance of Chinas skillfully dancing Robot

In a stunning display of creativity, 16 humanoid robots from China's leading robotics company Unitree took the spotlight at CCTV's annual Spring Festival Gala.