How to merge multiple messages on 1 page from an Excel table in Word 2016
The following article will guide you in detail how to merge multiple messages on one page from Excel worksheet in Word 2016 to help you create invitations, certificates . quickly and accurately.
To be able to merge mail from an Excel table, you need to prepare 2 data files:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 1
Note that the data file from Excel containing the list of header rows must be the first row on the top, so you do not insert any of the above content:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 2
The Word file contains the content of the form you need to merge:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 3
For example, to create a health examination, follow these steps:
Step 1: Copy the content of the message (do not copy the frame and the border) by selecting content -> right-click and choose Copy:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 4
Step 2: Go to Maillings tab -> Start Mail Merger -> labels:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 5
Step 3: The Label Option dialog box appears, click New Label .
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 6
Step 4: In the Label Detail dialog box make the following options:
- Page Size: Select a vertical A4 paper size (depending on how you create the letter to select a paper size)
- Number across: Select the number of columns of labels on a page to select value 2 (the number of mailing labels on a page horizontally consists of 2 columns)
- Number down: Number of labels selected value 4 (number of letter labels on a page arranged vertically 4 letters)
Note: Number across = 2, number down = 4 => On a page there are 8 letters divided into 2 columns on 1 page.
- Top margin: Choose the upper margin for the label, here choose 5mm
- Side margin: Select the left margin for the label here choose 5mm
- Label height: Select the height for labels, you need to calculate the height as follows:
+ A4 paper size 29.7cm high, in the upper section choose Number down = 4 ie 1 page contains 4 letters or 4 labels => the height of each label = (paper height - upper margin - lower margin): 4 = (29.7-0.5-0.5) = 6.4cm
- Label width: The width of the label, above select a page with 2 columns (number down = 2) => Label width is calculated = (paper width - left and right margins): 2 = (29.7- 0.5-0.5): 2 = 9.5cm
- Vertical pitch: The distance between the labels vertically = the height of the label + the top margin + the bottom margin = 6.4 + 0.5 + 0.5 = 7.4cm
- Horizontal pitch: The distance between the labels horizontally = the width of the label + left margin + right margin = 9.5 + 0.5 + 0.5 = 10.5cm
Note that the above values are calculated depending on how you selected the number of labels per page.
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 7
Step 5: Click OK -> select the label name just created -> click OK:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 8
Step 6: After selecting OK the dialog box to use the label -> system to delete data on the page -> click OK:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 9
Step 7: The result has created a label with 8 frames on 1 page divided into 2 columns:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 10
Step 8: Click on the first label to paste the content copied from step 1 -> get the results:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 11
Step 9: Create borders for labels:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 12
Step 10: Change the background color and border for the label:
- Right-click and choose Format shape:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 13
- Select no fill color
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 14
- Adjust the border color, style and width of the border:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 15
Step 11: After creating the border of the label, click the Update label icon to create the remaining labels:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 16
Frame result for labels:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 17
Step 12: Perform additional fields from the Excel file:
- Go to Mailling tab -> Select Recipients:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 18
- Find the path to the Excel file containing the list:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 19
- Select Sheets containing content to create labels -> click OK:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 20
- Click the mouse at the first label position to select the data field by clicking Insert label field -> selecting the corresponding field:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 21
- After selecting the data fields for the first label -> click update label -> all labels are created:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 22
- Click Prewiew Result to preview the newly created content:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 23
Step 13: Press Ctrl + S to save the content of the newly created message:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 24
Step 14: After clicking Save you have created the message from the Excel file:
How to merge multiple messages on 1 page from an Excel table in Word 2016 Picture 25
The above is a detailed guide on how to merge multiple messages on 1 page from an Excel table in Word 2016. I wish you success!
You should read it
- How to merge text, merge Mail Merge messages in Word 2016
- Merge cells in Excel
- Mix text, merge messages, mix Excel tables into Word 2007 documents
- How to merge messages that contain images in Word 2016
- How to insert a table, create a table in Word 2016
- How to merge multiple Word files into a single file
- How to merge multiple Word files into 1 file, merge multiple Word documents into one
- How to create a table, insert a table in Excel 2016
- How to type page numbers in Word 2016
- How to merge 2 pages into 1 page in Word
- How to separate tables and join Word tables
- How to install Word and Excel in Office 2016 only
May be interested
How to merge messages that contain images in Word 2016
How to convert Inches to centimeters in Word 2016
Fix lower case i automatically converted to capital I in Word
How to customize the look and feel in Office 2016
Free applications that replace Microsoft Office
Summary of PowerPoint templates, beautiful Slide templates