Insert Image Using Mail Merge From Excel to Word Document

Using mail merge, you can easily insert images into the Word Document using an Excel Sheet.
Learn, how to add custom images in a Mail Merge document. With INCLUDEPICTURE command merging graphics into the Word Documents are very easy.

[kultur]

It's worth noting that the reason you have to add a backslash is that a backslash when processed as code tells the code to interpret the next character in the sequence as text instead of code. This allows special characters that would normally affect the output of the command to be processed literally instead of functionally as code. So if a backslash was not added, Word sees E:\Docs\Picture1.jpg as E:DocsPicture1.jpg. When you add a backslash in front of a backslash Word gets the signal from the first backslash to interpret the next character (the second backslash) as literal text. You don't even have to create hyperlinks in Excel, you can just type the text of the location as long as the location is correctly formatted to be interpreted by Word. A network location that would normally be \\server\drive\file.jpg you could just type in an Excel cell as \\\\server\\drive\\file.jpg.

[KatieStriplin]

I tired this multiple times but cannot get it to work. I followed all of the steps perfectly and when I click CTRL+A to select all the docs and then press F9, nothing happens and the picture isnt there. can you advise any solution?

[littleyarrasteinerschool]

It was working great but suddenly stopped. Previously after doing Cntrl + F9 and adding INCLUDEPICTURE " followed by the insert merge field, the text would disappear but it no longer does and so F9 does not bring up the picture. Ever had this issue?

[knmacdonald]

Hello - THANKS for this information but it is not working on my MAC. How do I need to do it for a MAC from Excel to Word? I do not have an "E:" or "C:\\" drive. Mine simply has the name like "mbp-nm\\MAC SSD\\users\\..." Can you please help me? Thanks.

[melissasailors]

This doesn't work in Word 2016. It just shows the file name. No amount of refreshing makes any difference. File name and path are correct. Coding is correct. Saved as correct version of Word.

[Estefania]

This gave me a glimpse of hope on my project: I'm here in 2024, with a mac. When I insert a hyperlink in a field, it gets shortened /.../.../.../Downloads/Maps etc. When I click "finish and merge" and do the select all, press f9, the images wont load an an error box will appear instead. Does anyone know how to fix this?

[crystalmorgan]

I continue to get "ERROR! File name not found". How do I fix that?

[watthanakornweenuttranont]

is there the way to match pictures to the data in mail merge in case of using label template? (many data and pictures are in the same page)

[jchasko]

Get rid of the background music and get yourself a microphone

[martinosullivanirl]

Did anyone actually get this to work? All I get is a message saying that the file cant be found. I have spent 5 hours on this now!

[niloobolsinlaphathanoo]

Ctrl+F9> { INCLUDEPICTURE " } > {Ctrl+A > F9

[hilmiafifelrifqie]

It doesn't work in my Mac, any solution?

[pramodmishra]

Too problem. Plz work out before show.

[keto.sensei]

where is abdullah?
oh there you are 🤣🤣

[joeylozano]

Thanks for the great video. Is there a way, pictures will show even if it is not to "Edit Individually"? Thanks!

[Nikhilmandekar]

Hello,

Amazing video, thank you so much for sharing your knowledge.

I am facing some issues with this technique, Can you please provide some more details.

I am working on word file in which there are no same pages, that word file is like Novel.

I have 50 screenshots in my system.

I want specific screenshot in specific place.

But it is showing same screenshot everywhere.


There are 50 pages in which I need specific screenshot in specific place.

(There is no same template,
There is one novel in which I want many screenshots.)

Can you please advise,
It will save my too much time in office.

[KangleiEdufun]

U don't have to choose one by one just copy from first one and then paste to other except u need to change manual the name of each person

[hamisuyusuf]

Hello Sir!
I've tried the steps youve shown in this tutorial and it works in the first place but upon trying again next time the picture refuses to show. May be I need the best means of editing the picture for mailing, what can I do for the above said problem not to repeat it self? Help!

[chrisparrott]

I am getting an error message "The link image cannot be displayed. The file may have been moved, renamed, or deleted..." Any ideas what might be causing that? I followed your video and made sure to add the two \\ in the file paths in the cell.

[alexpark]

thank you.. I have gained extra knowledge and you gained one more subscriber..