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

Top 5 best automatic home coffee makers

Top 5 best automatic home coffee makers

The automatic home coffee maker is a modern and professional product, bringing you and your family delicious cups of coffee with just a few quick steps.

Difference between regular TV and Smart TV

Difference between regular TV and Smart TV

Smart TVs have really taken the world by storm. With so many great features and the ability to connect to the Internet, technology has changed the way we watch TV.

Why doesnt the freezer have a light but the refrigerator does?

Why doesnt the freezer have a light but the refrigerator does?

Refrigerators are familiar appliances in families. Refrigerators usually have 2 compartments, the cool compartment is spacious and has a light that automatically turns on every time the user opens it, while the freezer compartment is narrow and has no light.

2 Ways to Fix Network Congestion That Slows Down Wi-Fi

2 Ways to Fix Network Congestion That Slows Down Wi-Fi

Wi-Fi networks are affected by many factors beyond routers, bandwidth, and interference, but there are some smart ways to boost your network.

How to Downgrade from iOS 17 to iOS 16 without Losing Data using Tenorshare Reiboot

How to Downgrade from iOS 17 to iOS 16 without Losing Data using Tenorshare Reiboot

If you want to go back to stable iOS 16 on your phone, here is the basic guide to uninstall iOS 17 and downgrade from iOS 17 to 16.

What happens to the body when you eat yogurt every day?

What happens to the body when you eat yogurt every day?

Yogurt is a great food. Is it good to eat yogurt every day? What will happen to your body when you eat yogurt every day? Let's find out together!

Which type of rice is best for health?

Which type of rice is best for health?

This article discusses the most nutritious types of rice and how to maximize the health benefits of whichever rice you choose.

How to wake up on time in the morning

How to wake up on time in the morning

Establishing a sleep schedule and bedtime routine, changing your alarm clock, and adjusting your diet are some of the measures that can help you sleep better and wake up on time in the morning.

Rent Please! Landlord Sim Tips for Beginners

Rent Please! Landlord Sim Tips for Beginners

Rent Please! Landlord Sim is a simulation mobile game on iOS and Android. You will play as a landlord of an apartment complex and start renting out an apartment with the goal of upgrading the interior of your apartments and getting them ready for rent.

Latest Bathroom Tower Defense Codes and How to Enter Codes

Latest Bathroom Tower Defense Codes and How to Enter Codes

Get Bathroom Tower Defense Roblox game codes and redeem them for exciting rewards. They will help you upgrade or unlock towers with higher damage.

Structure, symbols and operating principles of transformers

Structure, symbols and operating principles of transformers

Let's learn about the structure, symbols and operating principles of transformers in the most accurate way.

4 Ways AI Is Making Smart TVs Better

4 Ways AI Is Making Smart TVs Better

From better picture and sound quality to voice control and more, these AI-powered features are making smart TVs so much better!

Why ChatGPT is better than DeepSeek

Why ChatGPT is better than DeepSeek

DeepSeek initially had high hopes. As an AI chatbot marketed as a strong competitor to ChatGPT, it promised intelligent conversational capabilities and experiences.

Meet Fireflies.ai: The Free AI Secretary That Saves You Hours of Work

Meet Fireflies.ai: The Free AI Secretary That Saves You Hours of Work

It's easy to miss important details when you're jotting down other essentials, and trying to take notes while chatting can be distracting. Fireflies.ai is the solution.

How to raise Axolotl Minecraft, tame Minecraft Salamander

How to raise Axolotl Minecraft, tame Minecraft Salamander

Axolot Minecraft will be a great assistant for players when operating underwater if they know how to use them.