Mail Merge PICTURES to documents [step by step]

[@PixelFusionGraphicVillage]

This is fantastic I love it! ❤

[@paphitisn]

I am glad, thank you for your comment

[@evasco1979]

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.

[@Himps]

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!

[@paphitisn]

Really glad to hear this tutorial proved useful for you. Thanks for your comment and for sharing how you used this mailmerge method.

[@dzungdo1784]

Your instruction is very clear and I got my document working. Thank you.

[@paphitisn]

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-ok1sc1gf3m]

Many thanks Sir. It is very helpful. Perfectly works in my computer

[@paphitisn]

That is great to hear. Thanks for your comment.

[@marisolsauer2225]

Excellent Tutorial, Thank you for sharing. Extremely Helpful!

[@paphitisn]

I am glad you found this useful

[@ranganadhamtn7530]

Amazing, Thank you very much

[@quamrulahsan335]

Explained amazingly! Thanks a lot.

[@paphitisn]

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.

[@Donories]

thanks legend, finally got that to work thanks to you!

[@paphitisn]

Awesome, well done. Glad the tutorial helped. Thanks for you comment.

[@morganhill4601]

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.

[@paphitisn]

Check this out kzbin.info/www/bejne/hIfOXouAlJl-btE

[@moomoo644]

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.

[@everyoneyou9350]

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) ?

[@paphitisn]

how are the drawings saved so that you can import them through mail merge?

[@GowthamD-xy9hu]

You are really Incredible Sir..! Thanks a lot

[@paphitisn]

Thank you for your comment

[@GowthamD-xy9hu]

@@paphitisn My pleasure sir!

[@user-fd3tb6py6x]

I got "error! file name not specified" even though I made sure the path is correct in my excel database?

[@deepankararya005]

Thanks !

[@theforce3810]

Just Fantastic !!

[@paphitisn]

Thanks for your comment

[@theforce3810]

@@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.

[@paphitisn]

@@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.

[@theforce3810]

@@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.

[@paphitisn]

@theforce3810 that is a good solution. Date formats are a pain.

[@dr.suryaprakashsharma5464]

nice explaination

[@paphitisn]

Thanks

[@paphitisn]

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-fq7pk5tn7o]

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-io3it2dz6c]

i GOT THE ERROR FILE NAME NOT SPECIFIED ERROR. Any ideas?

[@paphitisn]

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.

[@chrissyslack2077]

I also got this error

[@paphitisn]

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.

[@paphitisn]

​@@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-pt7uu]

Getting same error doing everything same

[@SumeetPatil-zb6xl]

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

[@paphitisn]

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.

[@suryakantthakur1879]

Excellent...

[@neremoli4990]

Interesting, could you please write the macro texts for the picture?

[@lifeonly1]

Nice work, how to add picture behind text in this example.?

[@paphitisn]

If, before you merge you place the text box behind the text, then after you merge all pictures should be behind the text.

[@rcsontag]

Includepicture is not recognized by MS Word.

[@mansoorhassan6638]

very nice..

[@robmendell6338]

(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.)

[@moomoo644]

is there anyway we can save the linking path on the doc for future use?

[@paphitisn]

Not that i know of.

[@moomoo644]

Some of the Microsoft forum showed that it's a must to change the single slashes into double slashes. Is it really necessarily?

[@paphitisn]

Go with whatever works for you.

[@moomoo644]

@@paphitisn i tried once. It works with your method. I was curious why others do the extra work.

[@shaunbradby676]

perfect thanks for that...

[@Estefania817]

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?

[@paphitisn]

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.

[@DavidKClements]

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

[@paphitisn]

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.

[@DavidKClements]

@@paphitisn​​⁠thanks 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-xy9hu]

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]

if the signatures are images it should work as explained in the video.

[@GowthamD-xy9hu]

@@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?

[@videoawesomenessbylisa5803]

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?

[@paphitisn]

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-rj8kl5mq3n]

control f9 doesn't work on my word :(

[@paphitisn]

You may need to also hold down the FN (function )key,

[@ShahBusinessPoint]

Shift f9

[@oscarwilliams2023]

hey, it's me again

[@wongcheongway5810]

I successfully added the pictures, but there are five different images, and it's only displaying the picture from the first row of excel.

[@paphitisn]

not too sure what you mean.

[@NYSEEDGrant]

I have the same problem

[@wongcheongway5810]

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.

[@NYSEEDGrant]

@@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

[@wongcheongway5810]

Hi, after Identified, I add \D can solve my problem. which is {{INCLUDEPICTURE{IF TRUE}}\D}@@NYSEEDGrant

[@m.murtazamadha962]

cntrl F9 command on mac is not working ... what is the command in mac which has to be used

[@navigatorsfieldsupportcent9548]

command-fn-F9 worked for me

[@gauravgupta5616]

Photo sare same in all document

[@paphitisn]

i think you are saying the photo is the same in all documents. Please check your data source.

[@gauravgupta5616]

@@paphitisn i already checked my xl file