How to merge messages that contain images in Word 2016
The following article will guide you in detail how to merge letters containing images in Word 2016 to help you create student, student, staff cards . quickly and accurately.
To be able to merge mail from an Excel table you need to prepare 3 data files:
- Mail merge template file with Word 2003 format
- The Excel file contains a mailing list
- Folders containing Photos for mail merge
How to merge messages that contain images 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 messages that contain images in Word 2016 Picture 2
The Word file contains the content of the form you need to merge:
How to merge messages that contain images in Word 2016 Picture 3
The folder containing the images, note the image file name must match the name entered in the Photo column in Excel file:
How to merge messages that contain images in Word 2016 Picture 4
For example, to create a student ID card, follow these steps:
Step 1: Copy the content of the board containing student information and photos by selecting the content -> right-click and choose Copy:
How to merge messages that contain images in Word 2016 Picture 5
Step 2: Go to Maillings tab -> Start Mail Merger -> labels:
How to merge messages that contain images in Word 2016 Picture 6
Step 3: The Label Option dialog box appears, click New Label .
How to merge messages that contain images in Word 2016 Picture 7
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 messages that contain images in Word 2016 Picture 8
Step 5: Click OK -> select the label name just created -> click OK:
How to merge messages that contain images in Word 2016 Picture 9
Step 6: After selecting OK the dialog box to use the label -> system to delete data on the page -> click OK:
How to merge messages that contain images in Word 2016 Picture 10
Step 7: The result has created a label with 8 frames on 1 page divided into 2 columns:
How to merge messages that contain images in Word 2016 Picture 11
Step 8: Click on the first label to paste the content copied from step 1 -> get the results:
How to merge messages that contain images in Word 2016 Picture 12
Step 9: Put the cursor in the position to insert the image of the first label -> on the Insert tab -> Picture:
How to merge messages that contain images in Word 2016 Picture 13
Step 10: Select the path to the corresponding image file to be inserted -> pay attention to select Link to File without selecting Insert if not mixed the error message:
How to merge messages that contain images in Word 2016 Picture 14
Result of inserting the image into the card:
How to merge messages that contain images in Word 2016 Picture 15
Step 11: Press the key combination Alt + F9 to open the code window for the image:
How to merge messages that contain images in Word 2016 Picture 16
Step 12: Go back to the folder containing images -> Copy the path to the folder:
How to merge messages that contain images in Word 2016 Picture 17
Step 13: Replace the path of the image file with the path of the copied folder:
How to merge messages that contain images in Word 2016 Picture 18
Step 14: In the Mailings tab, click Select Recipients -> Use an Existing list ( to select the Excel file containing the list to insert) -> The dialog box will appear and select the path to the Excel file containing the list:
How to merge messages that contain images in Word 2016 Picture 19
Step 15: Select the sheet name containing the list -> click OK:
How to merge messages that contain images in Word 2016 Picture 20
Step 16: Place the mouse cursor at the location containing the file name of the image -> Click the Maillings tab -> Insert Merge Field -> select the photo field corresponding to the image file name:
How to merge messages that contain images in Word 2016 Picture 21
The result of inserting the Photo field into the image:
How to merge messages that contain images in Word 2016 Picture 22
Similarly select the corresponding school for student name, date of birth .
Step 16: Press the key combination Alt + F9 to return to the original mode -> click the Update labels icon :
How to merge messages that contain images in Word 2016 Picture 23
After Update labels all labels are updated:
How to merge messages that contain images in Word 2016 Picture 24
Step 17: Click Finish & Merge -> Edit Individual Document to check whether the image mixing process has been successful:
How to merge messages that contain images in Word 2016 Picture 25
Step 18: Click the All button to preview all the labels:
How to merge messages that contain images in Word 2016 Picture 26
Results of updating all labels:
How to merge messages that contain images in Word 2016 Picture 27
However, the image field has not been updated -> press the F5 key to refresh -> get the results:
How to merge messages that contain images in Word 2016 Picture 28
If you press F5, the image has not been updated, please check the image file path again, in the process of inserting the selected image Link to file or not, the file containing the sample letter is in Word 2003 format or not.
Step 19: Go back to the .docx file to copy the title to create student cards:
How to merge messages that contain images in Word 2016 Picture 29
Step 20: Paste the contents of the first mixed card:
How to merge messages that contain images in Word 2016 Picture 30
Step 21: Update the Labels for all the resulting labels:
How to merge messages that contain images in Word 2016 Picture 31
So you've successfully merged the mail containing images, the rest you just need to Save the newly created file into your drive.
In the process of mail merge containing images you should note the following:
- File containing mail merge template must be in Word 2003 format (.doc)
- The name of the image file to be inserted must match and match the student order in the Excel file
- At the image insertion step, select Link to file mode without selecting Insert.
Above is a detailed guide on how to merge letters containing images in Word 2016. I wish you success!
You should read it
- How to merge text, merge Mail Merge messages in Word 2016
- How to merge mail (Mail Merge) in Word
- How to fix number formatting errors when using Mail Merge in Word
- Mix text, merge messages, mix Excel tables into Word 2007 documents
- How to merge letters and documents (Mail Merge) in Word 2016
- Improved email performance with the Microsoft Word Mail Merge feature
- How to Mail Merge in Microsoft Word
- How to Merge Mail in Microsoft Word
- How to Perform a Mail Merge in Word 2010
- Merge cells in Excel
- How to Create a Mail Merge in Publisher
- How to merge multiple messages on 1 page from an Excel table in Word 2016
May be interested
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
Add rows and columns - Delete rows and columns - Align rows and columns evenly in the Word table