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

Leave a Comment

What Young Riders Should Know About Moving Their Motorcycles Across Cities

What Young Riders Should Know About Moving Their Motorcycles Across Cities

Long-distance travel can involve heavy traffic, changing weather conditions, and rider fatigue. If you are also dealing with the responsibilities of moving home, such as packing belongings or coordinating accommodation, a long ride may add unnecessary pressure to an already busy schedule.

Solving Microsoft Teams Shortcut Error Not Opening

Solving Microsoft Teams Shortcut Error Not Opening

Tired of Microsoft Teams shortcut error preventing you from opening the app? Follow our expert, step-by-step guide with the latest fixes for instant resolution. Works on Windows, Mac & web – no tech skills needed!

Solving Microsoft Teams Task Management Sync Error

Solving Microsoft Teams Task Management Sync Error

Tired of Microsoft Teams Task Management Sync Error halting your workflow? Follow our proven, step-by-step fixes to resolve sync issues fast and restore seamless task collaboration. No tech expertise needed!

Troubleshooting Microsoft Teams Wiki Error Formatting

Troubleshooting Microsoft Teams Wiki Error Formatting

Struggling with Microsoft Teams Wiki Error Formatting? This step-by-step guide reveals proven fixes for common wiki tab issues, ensuring smooth editing and collaboration in Teams. Get back to productive wikis fast!

How to Fix Microsoft Teams Installation Error for Linux

How to Fix Microsoft Teams Installation Error for Linux

Struggling with Microsoft Teams installation error on Linux? Discover step-by-step fixes for Ubuntu, Fedora & more. Resolve dependency issues, crashes, and errors quickly with our ultimate guide. Get Teams running smoothly today!

Solving Microsoft Teams Error Page Not Loading

Solving Microsoft Teams Error Page Not Loading

Struggling with Microsoft Teams "Error Page" not loading? Get step-by-step fixes for desktop, web, and mobile. Solve Microsoft Teams Error Page issues quickly and resume seamless teamwork today.

Solving Microsoft Teams Error Screenshot Issues

Solving Microsoft Teams Error Screenshot Issues

Tired of Microsoft Teams "Error Screenshot" blocking your workflow? Get proven, step-by-step solutions to resolve screenshot errors in Teams instantly and boost productivity. No tech skills needed!

How to Fix Microsoft Teams Error U User

How to Fix Microsoft Teams Error U User

Tired of Microsoft Teams "Error U" User blocking your chats? Get proven, step-by-step fixes to clear cache, reset, and restore seamless collaboration instantly.

Where are Microsoft Teams Registry Keys Located on Windows 11?

Where are Microsoft Teams Registry Keys Located on Windows 11?

Unlock the precise locations of Microsoft Teams registry keys on Windows 11. Step-by-step guide to find, access, and safely tweak them for optimal performance and troubleshooting. Essential for IT pros and Teams enthusiasts.

How to Fix Microsoft Teams Training Error Video Lag

How to Fix Microsoft Teams Training Error Video Lag

Tired of Microsoft Teams "Training Error" Video Lag ruining your meetings? Follow our step-by-step guide with the latest fixes for smooth video calls—no more frustration!