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!