

Then in “Select Table” dialog box, select the right worksheet and click “OK”.Next, click “OK” in “Confirm Data Source” dialog box.Now in the “Select Data Source” window, select the file and click “Open”.Then click “Select Recipients” and choose “Use Existing List”.Then open Word and finish all other editing.And remember to replace the “\” in file path with “\\”, such as below: First and foremost, in your source Excel file, insert a new column to put the location of your pictures.Method 1: Place Picture Location into Excel File To solve this issue, the following 2 methods are exactly what you will need.

However, we can’t possibly insert pictures into Excel file directly, thus while using mail merge in Word, it’s unlikely to get the corresponding images. When create credentials, we often need to insert pictures. In this article, there are 2 effectual ways for you to batch insert multiple pictures into your Word document via mail merge.
