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.
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?
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?
Works perfectly, thank you. (From my experiments, though, you must make sure that the link is the FULL link, including the drive. So, if the image is in the same folder as your Excel file (or in a folder below it), the link MUST NOT be a relative link. The relative link will work when you click on it in Excel, but does not seem to work in the mail merge.
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.
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?
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.
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.
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!
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.
You have to add a backslash before every already existing backslash. The reason being is that a backslash in the code is actually a command that tells the code to skip the next character. So E:\Docs\Pic would be interpreted by the code as E:ocsic and that is not a location that contains anything.
I do that with 2 steps=> In Excell column 1 I put the base image url that all images have. Then in column 2 I put a number, which then I can drag downwards with CTRL so the number increasesautomatically. In column 3 I put the formula to merge both columns. Ofcourse you have to make sure that whenever you generate the images, you generate numbers (I do that with Qr codes)
I am using ms office 2016 , when i am trying to insert the image using INCLUDE PICTURE COMMAND, i am pressing ctrl + F9 but i am not getting the bracket symbol . When Iam pressing ctrl + F9 , my windows is restarting . can you suggest what to do?
I do that with 2 steps=> In Excell column 1 I put the base image url that all images have. Then in column 2 I put a number, which then I can drag downwards with CTRL so the number increasesautomatically. In column 3 I put the formula to merge both columns. Ofcourse you have to make sure that whenever you generate the images, you generate numbers (I do that with Qr codes)
Why are struggling to find hyperlink tab? This is unnecessary making the video long. Also it seems you are lost while speaking. Be prepared before making videos for such small steps.
The photos are not in Excel, it's just a hyperlink that links to the photo. So if you remove the photos from their location, then the hyperlink will lead to a missing file.