Amazing, so much learning in one single video! Thank you very much.
@paphitisnАй бұрын
Your comment "so much learning" is what i want my tutorials to be about. Thank you for your comment.
@Himps2 ай бұрын
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!
@paphitisn2 ай бұрын
Really glad to hear this tutorial proved useful for you. Thanks for your comment and for sharing how you used this mailmerge method.
@dzungdo17845 ай бұрын
Your instruction is very clear and I got my document working. Thank you.
@paphitisn5 ай бұрын
That is great. Thanks for the comment.
@MikeMushovic Жыл бұрын
Nice work! Thank you for making this Nicos. One note: So far, in my experience, the '\D' is not optional.
@user-ok1sc1gf3m5 ай бұрын
Many thanks Sir. It is very helpful. Perfectly works in my computer
@paphitisn5 ай бұрын
That is great to hear. Thanks for your comment.
@marisolsauer22255 ай бұрын
Excellent Tutorial, Thank you for sharing. Extremely Helpful!
@paphitisn5 ай бұрын
I am glad you found this useful
@ranganadhamtn753013 күн бұрын
Amazing, Thank you very much
@quamrulahsan33510 ай бұрын
Explained amazingly! Thanks a lot.
@paphitisn10 ай бұрын
Glad it was helpful! Thanks for your comment
@evasco1979Ай бұрын
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").
@louisverelst8339Күн бұрын
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?
@louisverelst8339Күн бұрын
btw, manual entry using the key { and } seperatly does not work.
@louisverelst8339Күн бұрын
got it: ctrl fn f9 (keyboqrd issue)
@paphitisnКүн бұрын
You may have to use the function key also on your keyboard. You could also use the onscreen keyboard.
@Donories11 ай бұрын
thanks legend, finally got that to work thanks to you!
@paphitisn11 ай бұрын
Awesome, well done. Glad the tutorial helped. Thanks for you comment.
@morganhill46015 ай бұрын
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.
@paphitisn5 ай бұрын
Check this out kzbin.info/www/bejne/hIfOXouAlJl-btE
@moomoo64423 күн бұрын
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.
@mochigamingdeumNPC Жыл бұрын
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?
@paphitisn Жыл бұрын
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.
@everyoneyou93503 ай бұрын
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) ?
@paphitisn3 ай бұрын
how are the drawings saved so that you can import them through mail merge?
@GowthamD-xy9hu4 ай бұрын
You are really Incredible Sir..! Thanks a lot
@paphitisn4 ай бұрын
Thank you for your comment
@GowthamD-xy9hu4 ай бұрын
@@paphitisn My pleasure sir!
@user-fd3tb6py6x10 ай бұрын
I got "error! file name not specified" even though I made sure the path is correct in my excel database?
@deepankararya0052 ай бұрын
Thanks !
@theforce38106 ай бұрын
Just Fantastic !!
@paphitisn6 ай бұрын
Thanks for your comment
@theforce38106 ай бұрын
@@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.
@paphitisn6 ай бұрын
@@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.
@theforce38106 ай бұрын
@@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.
@paphitisn6 ай бұрын
@theforce3810 that is a good solution. Date formats are a pain.
@dr.suryaprakashsharma54645 ай бұрын
nice explaination
@paphitisn5 ай бұрын
Thanks
@paphitisn5 ай бұрын
Thanks
@phillic004 Жыл бұрын
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.
@paphitisn Жыл бұрын
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.
@user-fq7pk5tn7o4 ай бұрын
I've been at this for two days now and still having some trouble. When I test export as PDF, the pictures also disappear. With or without the /D What am I doing wrong?
@user-io3it2dz6c7 ай бұрын
i GOT THE ERROR FILE NAME NOT SPECIFIED ERROR. Any ideas?
@paphitisn7 ай бұрын
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.
@chrissyslack20776 ай бұрын
I also got this error
@paphitisn6 ай бұрын
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.
@paphitisn6 ай бұрын
@@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.
@Vishalgupta-pt7uu5 ай бұрын
Getting same error doing everything same
@SumeetPatil-zb6xl2 ай бұрын
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
@paphitisn2 ай бұрын
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.
@sherrik.8333Ай бұрын
Did you ever resolve this. I am having the same problem and the path is definitely correct for my images.
@suryakantthakur18794 ай бұрын
Excellent...
@neremoli49905 ай бұрын
Interesting, could you please write the macro texts for the picture?
@lifeonly19 ай бұрын
Nice work, how to add picture behind text in this example.?
@paphitisn9 ай бұрын
If, before you merge you place the text box behind the text, then after you merge all pictures should be behind the text.
@rcsontag24 күн бұрын
Includepicture is not recognized by MS Word.
@mansoorhassan663810 ай бұрын
very nice..
@robmendell63384 ай бұрын
(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.)
@moomoo64422 күн бұрын
is there anyway we can save the linking path on the doc for future use?
@paphitisn22 күн бұрын
Not that i know of.
@moomoo64428 күн бұрын
Some of the Microsoft forum showed that it's a must to change the single slashes into double slashes. Is it really necessarily?
@paphitisn28 күн бұрын
Go with whatever works for you.
@moomoo64428 күн бұрын
@@paphitisn i tried once. It works with your method. I was curious why others do the extra work.
@shaunbradby6765 ай бұрын
perfect thanks for that...
@Estefania8174 ай бұрын
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?
@paphitisn4 ай бұрын
I am not a mac user but you need to make sure that you have the complete path inserted.
@ennykraftАй бұрын
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.
@paphitisnАй бұрын
Interesting but good to know. I have never used it with labels. Will give ut a blast when i have a chance.
@ennykraftАй бұрын
@@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.
@paphitisnАй бұрын
@@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.
@DavidKClements2 ай бұрын
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
@paphitisn2 ай бұрын
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.
@DavidKClements2 ай бұрын
@@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?
@GowthamD-xy9hu4 ай бұрын
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..!
@paphitisn4 ай бұрын
if the signatures are images it should work as explained in the video.
@GowthamD-xy9hu4 ай бұрын
@@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?
@videoawesomenessbylisa580310 ай бұрын
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?
@paphitisn10 ай бұрын
i think you are referring to a different video, this one: kzbin.info/www/bejne/hIfOXouAlJl-btEsi=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
@user-rj8kl5mq3n7 ай бұрын
control f9 doesn't work on my word :(
@paphitisn7 ай бұрын
You may need to also hold down the FN (function )key,
@ShahBusinessPoint5 ай бұрын
Shift f9
@oscarwilliams2023 Жыл бұрын
hey, it's me again
@wongcheongway58109 ай бұрын
I successfully added the pictures, but there are five different images, and it's only displaying the picture from the first row of excel.
@paphitisn9 ай бұрын
not too sure what you mean.
@NYSEEDGrant9 ай бұрын
I have the same problem
@wongcheongway58108 ай бұрын
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.
@NYSEEDGrant8 ай бұрын
@@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
@wongcheongway58108 ай бұрын
Hi, after Identified, I add \D can solve my problem. which is {{INCLUDEPICTURE{IF TRUE}}\D}@@NYSEEDGrant
@m.murtazamadha96211 ай бұрын
cntrl F9 command on mac is not working ... what is the command in mac which has to be used
@navigatorsfieldsupportcent95487 ай бұрын
command-fn-F9 worked for me
@gauravgupta56165 ай бұрын
Photo sare same in all document
@paphitisn5 ай бұрын
i think you are saying the photo is the same in all documents. Please check your data source.