When editing individual documents or using the macro to export to Word, some have found that the images disappear. This is not an issue when merging to PDF. The above issue occurs with 365 users. If you are experiencing this issue and you need to merge to Word documents instead of PDF then use this syntax: {includepicture "{if equal {mergefield image}}"} The above syntax and solution is credited to users that have left this solution in the comments.
Hi, I can not get either way to show pictures. It merges when I run the macro with the above syntax in the picture text box but neither word or pdf show the pictures. Pulling my hair out now as I thought I was doing ever so well
I had quite a few challenges, but those were my own. This tutorial in the end worked for me. My project consisted of 5500 vouchers with numbers, but also pre-sized (1in width) brand logos as well as individual pre-sized (1in width) barcodes for each. Without this tutorial, this would have been a nightmare. Thanks again.
Thanks for this video, it pointed me in the right direction. In my version of office 365, I need to modify to reflect it as {INCLUDEPICTURE "{ IF EQUAL }" } for it to work.
Thank you for this excellent tutorial! I encountered an issue where images disappear in the final output when using the macro or 'Edit Individual Documents' option. However, I found that printing directly to PDF preserves the images correctly. Are you familiar with this behavior, and is there a way to maintain images while creating separate documents? Thanks for sharing your knowledge!
I am glad you found the tutorial useful. Yes i did find issues with the word document which were not issues when creating the PDF documents but cant remember exactly what the issues were. Did not put to much effort into resolving the issue as i simply modified my document template the way i wanted the final output to be and merged. It is only an issue if yo want to modify one or some of the merged documents individually which was never an issue for me so did not dig deeper.
@@paphitisn Thank you so much for your help! I found the solution in the comments - for Office 365 users, the correct syntax is {includepicture "{if equal {mergefield image}}"} instead of the {if true}. Your tutorial and community are incredibly helpful. Thanks again!
@@paphitisn Hi Nicos, The Date of Birth field in Excel is in dd-mmm-yyyy format, however the Date of Birth data in the Finish & Merge shows in mm/dd/yyyy. Can you guide and help on removing this error. Much appreciated.
@@theforce3810 In Word the date format is dependent on the language you have set up in the language options in File - Options. Add a language like English UK to the languages. You do not have to make it the default language. Go to Insert ribbon, then click Date and Time in the ribbon. Select the language and the date format you want as default and click on set as default button. That will be your default date format for Word.
@@paphitisn Hi Nicos, well I tried your suggested method. It didn't solve the issue, it could well be an error at my end. I did a work around of extracting the date, the month, the year and then concatenating them. Well it got the job done !!. Thanks.
This was fantastic and wonderful to use for making a photo directory with names of those in the photo listed below. THANK YOU SO MUCH. Following the channel for more awesome hacks!
Thank you for making this tutorial. However, I have issue in showing the pictures in the letter file, it only shows the path if I use alt+f9. I can see the pictures in my orginal file.
Hi Need one help I am using A4 size page in word, and using a text box of size 7 x 10 cm for the photo, but when I am converting it to PDF the image in the text box getting rotated automatically to the left. Is there any solution to it?
first i would troubleshoot by making the image smaller and see if it is the size of the image causing this. Based on this i would then start playing with margins, position and so on. I would also try saving a document with an image in as a pdf to see if it does the same thing.
I've watched your videos and I have this all set up, but I don't want to add pictures; I want to add personalized tables. Is this possible? I'm unsure of how to save my table to be able to link to the path. Thanks for the tutorials! They're precisely what I need.
great video, ctrl-f9 does not work on my keyboard, is there another way to get these special brackets and the function if true / insertpicture entered?
When are you getting this? Filename not specified? Check the names of the pictures in the data source. Doue check everything, you must have missed something.
Please check the path for the pictures also avoid using cloud drives like onedrive or protected drives like c:\. Use local folders like documents or desktop.
@@chrissyslack2077 Please check the path for the pictures also avoid using cloud drives like onedrive or protected drives like c:\. Use local folders like documents or desktop.
you want something like this: ruclips.net/video/taeWuL9VH18/видео.htmlsi=Dac2hiSS98Iq0ZdQ Mail merge. Quick method will be to create a table with cells representing the id card and mail merge the id data. If you want an image in there as well then you will have to mix the mail merge with the image merge. I have not done this before so if you get it working let us know. Personally i would do this with Access.
Thank you for this video! I'm making seat markers with names of countries and respective flags, and I need to add flags horizontally instead of vertically, is it possible to turn the picture 90º do right/left? Also, when all entries have the correct names but the same image shows in all entries, how do we solve it, in order to show all different images? I already checked the type files (both .jpg and .png, but the one showing is png) and the one single image that keeps showing in from an entry that is in the middle of the list (country starts with letter "S").
Hello, very good explanation, can we do the same with drawings instead of photos (I mean each file with its own drawing / without converting drawing to a photo) ?
Hi Nicos, this acually worked for me. However, i am getting multiple pop-us after its merged. "A field calculation error occurred in record 100" and so on. It seems like this pop-up is coming for all the rows that are empty. Although, my data is till 99th row. Could you suggest some checks I should do or change the syntax where it takes only the one which has data on it atltough your syntax says the same : : { inlcudepicture {if true }}
Is it a must to keep the column of the data source filled with jpg links? I hv a few data that doesn’t include any picture. They showed error message when I open the doc file. The others work fine.
Great video Nicos. I've been struggling with the INCLUDEPICTURE function since I switched from doc file to docx or docm. I followed your procedure verbatim and it's still not working. Have you modified and security settings to get this to work? I save the merged word doc to a .doc file and the images appear but other macros don't work. I've tried adding the image file location field in excel as hyperlinks, text fields, then tried double slashes and single slashes for the directory and I cannot get this to work. I'm considering switching to python scripting to try and get this to work as I simply cannot get image embedding to function properly.
Hi, the includepicture function is a pain. I did not modify any security fratures to do this but saying that, in general i have my security features set to allow all Macros by default so you may want to look at that. Ease also note that in my video, i to get blank spaces where the picture should go when i save the merged docx. This is why i print the merged document as a pdf as soo as it has merged. The doue slashes and everything eles that worked with .doc did not work for me either. For my purposes printing to .pdf was fine as i just wanted to print the certificates and keep a non editable electronic copy.
Hi, this is fantastic! It worked like a charm when I tried it as an example. However, now that I try it again with final set of images I have, I get an error "Error! Bookmark not defined." I have the same full folder and file path in excel. When I toggle the bookmark I see INSERTPICTURED:\FOLDER1\Temp.PNG. Please help
that error is associated with it not being able to find the files. Check your paths to the pictures. Let us know if you getting working and what your issue was as it could help others.
Love your videos ;) what would it be to send to all the created documents now to email to each individual person - with a subject and the add of the file or multiple files?
If you have merged as individual documents with unique file names then you already have data in the Excel spreadsheet you used to generate the files and you can use the same data source to email recipients with their individual certificate or document attached. You will need to use Merge Tools which you can download for free. It will allow you to email all recipients and you can attach files providing your data source contains a column with the file path for each file.
Thanks for sharing ur esteemed knowledge..! Sir, Actually I have to add Signatures of people with their name in same Cell of a Table in word file, But after running macros I'm unable to get those signatures in PDF ! Can You Please help..!
@@paphitisn I spent the rest of the day watching other videos and reading lots of web pages. IMO your method is the easiest. Thank you! Inserting the images in a text box or directly into the labels and then changing the wrap style stops them being a merge object. All images end up being the same. What worked was inserting a second table and then inserting the images the way you showed. But the images had to be resized in Photoshop to the measurements of the table or they would be too large in the individual documents. You'd have to resize every single one of them. I can't believe that there is so little documentation by Microsoft on the whole merge topic. They also haven't fixed any of the problems for years. I'm from Germany and if we insert a date it ends up being in the MM/DD/YYYY format no matter how you formatted it in Excel. You either have to convert with a TEXT function in Excel or edit the mergefields manually.
@@ennykrafti am glad that at least you resolved your issue thanks for sharing. For the resizing of the images you can automate this task by batch resizing them all at the same time with Photoshop. It will save the images in a designated folder. I will create a video tutorial on this soon but a qhick search will bring up the method to use.
I'm using a macbook, and when I copy the path of my images (of maps, it copies like this /Users/MyUser/Downloads/Maps-links/UniqueFilename.png ); or when I "insert a hyperlink" to my file (of maps, it looks like this ../../../../../Downloads/Maps-links/UniqueFilename.png ). However, when I follow through with the mail merge (finish and merge) an error comes up. I believe the problem is the way the paths are copied from my Mac. Do you know what I could do?
I'm frustrated. I used this macro successfully a month ago and now I can't use the same files I originally tested it on to work. I get an error message on a line of code "MasterDoc.MailMerge.DataSource.ActiveRecord = wdLastRecord" . Can you help?
i think you are referring to a different video, this one: ruclips.net/video/NVk-XJ_4K8o/видео.htmlsi=rsjjRWVo79TKPi42 if you are then i suggest that you make sure you have the locations specified in the DocFolder and PdfFolder in your spreadsheet still exist
Hi Nicos. Great vid. I tried this but I can’t seem to get the image to appear. No error occurs, it just doesn’t show. I wanted a different signature to appear based on the school house they belong to
i would suggest you double check you file path as specified in your spreadsheet. Make sure it is correct and that the file names of the images are correct.
Hi, I apologize if my explanation was unclear. Taking the certificate as an example, I have certificates for Dona, Cody, Lisa, Rachel, Edwin, and Eric. However, all the certificates are displaying Dona's picture. The rest of the information is correct.
@@wongcheongway5810 I hired someone on Upwork to help me with this issue. And he did an interesting thing which solved the problem, I have no idea what the logic behind is. So he changed all \ slashes in the url link within the excel sheet to double slashes like this \\. Let me know if that helps you too. You can easily change them in bulk with the find and replace feature
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
When editing individual documents or using the macro to export to Word, some have found that the images disappear. This is not an issue when merging to PDF.
The above issue occurs with 365 users. If you are experiencing this issue and you need to merge to Word documents instead of PDF then use this syntax:
{includepicture "{if equal {mergefield image}}"}
The above syntax and solution is credited to users that have left this solution in the comments.
Hi, I can not get either way to show pictures. It merges when I run the macro with the above syntax in the picture text box but neither word or pdf show the pictures. Pulling my hair out now as I thought I was doing ever so well
I had quite a few challenges, but those were my own. This tutorial in the end worked for me. My project consisted of 5500 vouchers with numbers, but also pre-sized (1in width) brand logos as well as individual pre-sized (1in width) barcodes for each. Without this tutorial, this would have been a nightmare. Thanks again.
5500 ! Wow, that is a lot. I am really glad this worked for you. Thank you for your comment.
Thanks for this video, it pointed me in the right direction. In my version of office 365, I need to modify to reflect it as {INCLUDEPICTURE "{ IF EQUAL }" } for it to work.
Thanks for your comment. I am glad the tutorial helped.
thanks i also use office 365, and it solved my problem
Thank you so much, it works well!!
@林林林林林园长 Glad to hear it, thanks for your comment.
Your instruction is very clear and I got my document working. Thank you.
That is great. Thanks for the comment.
Excellent Tutorial, Thank you for sharing. Extremely Helpful!
I am glad you found this useful
Many thanks Sir. It is very helpful. Perfectly works in my computer
That is great to hear. Thanks for your comment.
Good explanation,even i was sorted
Thank you so much for making this tutorial, very helpfull, saved me hours.
I am glad this helped you. Thanks for your comment
Amazing, so much learning in one single video! Thank you very much.
Your comment "so much learning" is what i want my tutorials to be about. Thank you for your comment.
Explained amazingly! Thanks a lot.
Glad it was helpful! Thanks for your comment
Please can you share a video of how to insert graph for individual during Mail merge
You mean a chart from Excel?
I dont get how will you have the chart for each person stored so that you can merge it.
If we are working on students report card,in such case we need individual graph
Please reply
@@deepalipawar794 I get that but where and how are the individual graphs saved
I don't know but is there any solution for this 😊
This is fantastic I love it! ❤
I am glad, thank you for your comment
Very nice sir❤
Thank you for this excellent tutorial! I encountered an issue where images disappear in the final output when using the macro or 'Edit Individual Documents' option. However, I found that printing directly to PDF preserves the images correctly. Are you familiar with this behavior, and is there a way to maintain images while creating separate documents? Thanks for sharing your knowledge!
I am glad you found the tutorial useful. Yes i did find issues with the word document which were not issues when creating the PDF documents but cant remember exactly what the issues were. Did not put to much effort into resolving the issue as i simply modified my document template the way i wanted the final output to be and merged. It is only an issue if yo want to modify one or some of the merged documents individually which was never an issue for me so did not dig deeper.
@@paphitisn Thank you so much for your help! I found the solution in the comments - for Office 365 users, the correct syntax is {includepicture "{if equal {mergefield image}}"} instead of the {if true}. Your tutorial and community are incredibly helpful. Thanks again!
@林林林林林园长 that is great to hear. I will add it as a pinned comment for other users.
Excellent...
Just Fantastic !!
Thanks for your comment
@@paphitisn Hi Nicos, The Date of Birth field in Excel is in dd-mmm-yyyy format, however the Date of Birth data in the Finish & Merge shows in mm/dd/yyyy. Can you guide and help on removing this error. Much appreciated.
@@theforce3810 In Word the date format is dependent on the language you have set up in the language options in File - Options. Add a language like English UK to the languages. You do not have to make it the default language. Go to Insert ribbon, then click Date and Time in the ribbon. Select the language and the date format you want as default and click on set as default button. That will be your default date format for Word.
@@paphitisn Hi Nicos, well I tried your suggested method. It didn't solve the issue, it could well be an error at my end. I did a work around of extracting the date, the month, the year and then concatenating them. Well it got the job done !!. Thanks.
@theforce3810 that is a good solution. Date formats are a pain.
This was fantastic and wonderful to use for making a photo directory with names of those in the photo listed below. THANK YOU SO MUCH. Following the channel for more awesome hacks!
Really glad to hear this tutorial proved useful for you. Thanks for your comment and for sharing how you used this mailmerge method.
Nice work! Thank you for making this Nicos. One note: So far, in my experience, the '\D' is not optional.
Thank you for making this tutorial. However, I have issue in showing the pictures in the letter file, it only shows the path if I use alt+f9. I can see the pictures in my orginal file.
Have a look at the pinned comment to see if that helps you.
nice explaination
Thanks
Thanks
Hi
Need one help
I am using A4 size page in word, and using a text box of size 7 x 10 cm for the photo, but when I am converting it to PDF the image in the text box getting rotated automatically to the left. Is there any solution to it?
first i would troubleshoot by making the image smaller and see if it is the size of the image causing this. Based on this i would then start playing with margins, position and so on. I would also try saving a document with an image in as a pdf to see if it does the same thing.
Amazing, Thank you very much
I've watched your videos and I have this all set up, but I don't want to add pictures; I want to add personalized tables. Is this possible? I'm unsure of how to save my table to be able to link to the path. Thanks for the tutorials! They're precisely what I need.
Check this out
ruclips.net/video/NVk-XJ_4K8o/видео.html
thanks legend, finally got that to work thanks to you!
Awesome, well done. Glad the tutorial helped. Thanks for you comment.
great video, ctrl-f9 does not work on my keyboard, is there another way to get these special brackets and the function if true / insertpicture entered?
btw, manual entry using the key { and } seperatly does not work.
got it: ctrl fn f9 (keyboqrd issue)
You may have to use the function key also on your keyboard. You could also use the onscreen keyboard.
i GOT THE ERROR FILE NAME NOT SPECIFIED ERROR. Any ideas?
When are you getting this? Filename not specified? Check the names of the pictures in the data source. Doue check everything, you must have missed something.
I also got this error
Please check the path for the pictures also avoid using cloud drives like onedrive or protected drives like c:\. Use local folders like documents or desktop.
@@chrissyslack2077 Please check the path for the pictures also avoid using cloud drives like onedrive or protected drives like c:\. Use local folders like documents or desktop.
Getting same error doing everything same
Thank you, this is great. But in my case, I want to create multiple ID card in single paper, please help!
*For the photo, it won't auto next record.
you want something like this:
ruclips.net/video/taeWuL9VH18/видео.htmlsi=Dac2hiSS98Iq0ZdQ
Mail merge. Quick method will be to create a table with cells representing the id card and mail merge the id data. If you want an image in there as well then you will have to mix the mail merge with the image merge. I have not done this before so if you get it working let us know. Personally i would do this with Access.
is there anyway we can save the linking path on the doc for future use?
Not that i know of.
Interesting, could you please write the macro texts for the picture?
Thank you for this video! I'm making seat markers with names of countries and respective flags, and I need to add flags horizontally instead of vertically, is it possible to turn the picture 90º do right/left?
Also, when all entries have the correct names but the same image shows in all entries, how do we solve it, in order to show all different images? I already checked the type files (both .jpg and .png, but the one showing is png) and the one single image that keeps showing in from an entry that is in the middle of the list (country starts with letter "S").
Nice work, how to add picture behind text in this example.?
If, before you merge you place the text box behind the text, then after you merge all pictures should be behind the text.
Hello, very good explanation, can we do the same with drawings instead of photos (I mean each file with its own drawing / without converting drawing to a photo) ?
how are the drawings saved so that you can import them through mail merge?
pretty sure you can refresh with F5 in explorer no?
In most cases but not all. Some devices even require a key combination to access function key.
Hi Nicos, this acually worked for me. However, i am getting multiple pop-us after its merged. "A field calculation error occurred in record 100" and so on. It seems like this pop-up is coming for all the rows that are empty. Although, my data is till 99th row. Could you suggest some checks I should do or change the syntax where it takes only the one which has data on it atltough your syntax says the same : : { inlcudepicture {if true }}
I got "error! file name not specified" even though I made sure the path is correct in my excel database?
This doesn't work if the photo is in drive/online link
is there an alternate way?
Is it a must to keep the column of the data source filled with jpg links? I hv a few data that doesn’t include any picture. They showed error message when I open the doc file. The others work fine.
Great video Nicos. I've been struggling with the INCLUDEPICTURE function since I switched from doc file to docx or docm. I followed your procedure verbatim and it's still not working. Have you modified and security settings to get this to work? I save the merged word doc to a .doc file and the images appear but other macros don't work. I've tried adding the image file location field in excel as hyperlinks, text fields, then tried double slashes and single slashes for the directory and I cannot get this to work.
I'm considering switching to python scripting to try and get this to work as I simply cannot get image embedding to function properly.
Hi, the includepicture function is a pain. I did not modify any security fratures to do this but saying that, in general i have my security features set to allow all Macros by default so you may want to look at that. Ease also note that in my video, i to get blank spaces where the picture should go when i save the merged docx. This is why i print the merged document as a pdf as soo as it has merged. The doue slashes and everything eles that worked with .doc did not work for me either. For my purposes printing to .pdf was fine as i just wanted to print the certificates and keep a non editable electronic copy.
Please sir help me add individual graph using Mail merge
Hi, this is fantastic! It worked like a charm when I tried it as an example. However, now that I try it again with final set of images I have, I get an error "Error! Bookmark not defined." I have the same full folder and file path in excel. When I toggle the bookmark I see INSERTPICTURED:\FOLDER1\Temp.PNG. Please help
that error is associated with it not being able to find the files. Check your paths to the pictures. Let us know if you getting working and what your issue was as it could help others.
Did you ever resolve this. I am having the same problem and the path is definitely correct for my images.
Some of the Microsoft forum showed that it's a must to change the single slashes into double slashes. Is it really necessarily?
Go with whatever works for you.
@@paphitisn i tried once. It works with your method. I was curious why others do the extra work.
Love your videos ;) what would it be to send to all the created documents now to email to each individual person - with a subject and the add of the file or multiple files?
If you have merged as individual documents with unique file names then you already have data in the Excel spreadsheet you used to generate the files and you can use the same data source to email recipients with their individual certificate or document attached. You will need to use Merge Tools which you can download for free. It will allow you to email all recipients and you can attach files providing your data source contains a column with the file path for each file.
Thanks for sharing ur esteemed knowledge..! Sir, Actually I have to add Signatures of people with their name in same Cell of a Table in word file, But after running macros I'm unable to get those signatures in PDF ! Can You Please help..!
if the signatures are images it should work as explained in the video.
@@paphitisn Thanks for your kind Reply sir, Yeah sir! those signatures are images in jpg format..! If you don't mind can i mail those data sir?
That worked with a regualar document but when I tried to with labels (for name tags) it didn't work. All the images were the same.
Interesting but good to know. I have never used it with labels. Will give ut a blast when i have a chance.
@@paphitisn I spent the rest of the day watching other videos and reading lots of web pages. IMO your method is the easiest. Thank you!
Inserting the images in a text box or directly into the labels and then changing the wrap style stops them being a merge object. All images end up being the same.
What worked was inserting a second table and then inserting the images the way you showed. But the images had to be resized in Photoshop to the measurements of the table or they would be too large in the individual documents. You'd have to resize every single one of them.
I can't believe that there is so little documentation by Microsoft on the whole merge topic. They also haven't fixed any of the problems for years. I'm from Germany and if we insert a date it ends up being in the MM/DD/YYYY format no matter how you formatted it in Excel. You either have to convert with a TEXT function in Excel or edit the mergefields manually.
@@ennykrafti am glad that at least you resolved your issue thanks for sharing. For the resizing of the images you can automate this task by batch resizing them all at the same time with Photoshop. It will save the images in a designated folder. I will create a video tutorial on this soon but a qhick search will bring up the method to use.
You are really Incredible Sir..! Thanks a lot
Thank you for your comment
@@paphitisn My pleasure sir!
Thanks !
very nice..
I'm using a macbook, and when I copy the path of my images (of maps, it copies like this /Users/MyUser/Downloads/Maps-links/UniqueFilename.png ); or when I "insert a hyperlink" to my file (of maps, it looks like this ../../../../../Downloads/Maps-links/UniqueFilename.png ). However, when I follow through with the mail merge (finish and merge) an error comes up. I believe the problem is the way the paths are copied from my Mac. Do you know what I could do?
I am not a mac user but you need to make sure that you have the complete path inserted.
I'm frustrated. I used this macro successfully a month ago and now I can't use the same files I originally tested it on to work. I get an error message on a line of code "MasterDoc.MailMerge.DataSource.ActiveRecord = wdLastRecord" . Can you help?
i think you are referring to a different video, this one:
ruclips.net/video/NVk-XJ_4K8o/видео.htmlsi=rsjjRWVo79TKPi42
if you are then i suggest that you make sure you have the locations specified in the DocFolder and PdfFolder in your spreadsheet still exist
control f9 doesn't work on my word :(
You may need to also hold down the FN (function )key,
Shift f9
Hi Nicos. Great vid. I tried this but I can’t seem to get the image to appear. No error occurs, it just doesn’t show. I wanted a different signature to appear based on the school house they belong to
i would suggest you double check you file path as specified in your spreadsheet. Make sure it is correct and that the file names of the images are correct.
@@paphitisnthanks for the reply. I’ve checked both of these. Do you mind if I share an unlisted video and see if you can see what I’m doing wrong?
I successfully added the pictures, but there are five different images, and it's only displaying the picture from the first row of excel.
not too sure what you mean.
I have the same problem
Hi, I apologize if my explanation was unclear. Taking the certificate as an example, I have certificates for Dona, Cody, Lisa, Rachel, Edwin, and Eric. However, all the certificates are displaying Dona's picture. The rest of the information is correct.
@@wongcheongway5810 I hired someone on Upwork to help me with this issue. And he did an interesting thing which solved the problem, I have no idea what the logic behind is. So he changed all \ slashes in the url link within the excel sheet to double slashes like this \\.
Let me know if that helps you too.
You can easily change them in bulk with the find and replace feature
Hi, after Identified, I add \D can solve my problem. which is {{INCLUDEPICTURE{IF TRUE}}\D}@@NYSEEDGrant
The sort cannot recognize number 10. If I have 12 pictures, when sort A to Z, it goes like 1 10 11 12 and then 2 3 4 5 6 7 8 9. What should I do?
Try 01, 02, 03, 04 etc up to 10, 11 so on
cntrl F9 command on mac is not working ... what is the command in mac which has to be used
command-fn-F9 worked for me
perfect thanks for that...
(Unless F5 shortcut has been usurped by another piece of software, in Windows File Explorer, you can press F5 (Fn+F5 on a laptop) to refresh.)
Includepicture is not recognized by MS Word.
Photo sare same in all document
i think you are saying the photo is the same in all documents. Please check your data source.
@@paphitisn i already checked my xl file
hey, it's me again
Please can you share a video of how to insert graph for individual during Mail merge
Please can you share a video of how to insert graph for individual during Mail merge