Mail Merge PICTURES to documents [step by step]

Рет қаралды 26,397

Күн бұрын

Learn how to add individual pictures with mail merge. In this tutorial i demonstrate how to mail merge DATA and PICTURES to generate student certificates. Merge to a single document or to individual documents with personalized file names.
0:00 Intro
1:50 Demo of final merge
3:33 The setup of our files (document, data and pictures)
5:23 how to get all the file paths of the pictures in to the data source
6:20 Bonus Windows 11 tip
7:23 making sure the picture file paths match the student record
8:30 Setting up the document so that the merged picture does not disrupt the document structure irrespective of the picture size
12:02 Adding the picture merge field and codes
16:02 Merging the document and saving the result. Why save as a PDF
19:17 Merging to individual files with unique file names for each document
20:46 setting up the data needed in the Excel data source
22:38 adding the picture merge field codes
Tutorial on Mail Merge basics:
• Mail Merge (Microsoft ...
Tutorial on how to setup a macro so as to merge to individual documents with personalized file names:
• Mail Merge to separate...

Пікірлер: 86

@evasco1979 3 күн бұрын

Amazing, so much learning in one single video! Thank you very much.

@paphitisn 3 күн бұрын

Your comment "so much learning" is what i want my tutorials to be about. Thank you for your comment.

@quamrulahsan335 8 ай бұрын

Explained amazingly! Thanks a lot.

@paphitisn 8 ай бұрын

Glad it was helpful! Thanks for your comment

@dzungdo1784 3 ай бұрын

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

@paphitisn 3 ай бұрын

That is great. Thanks for the comment.

@marisolsauer2225 3 ай бұрын

Excellent Tutorial, Thank you for sharing. Extremely Helpful!

@paphitisn 3 ай бұрын

I am glad you found this useful

@MikeMushovic 10 ай бұрын

Nice work! Thank you for making this Nicos. One note: So far, in my experience, the '\D' is not optional.

@user-ok1sc1gf3m 3 ай бұрын

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

@paphitisn 3 ай бұрын

That is great to hear. Thanks for your comment.

@Donories 9 ай бұрын

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

@paphitisn 9 ай бұрын

Awesome, well done. Glad the tutorial helped. Thanks for you 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.

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

@GowthamD-xy9hu 2 ай бұрын

You are really Incredible Sir..! Thanks a lot

@paphitisn 2 ай бұрын

Thank you for your comment

@GowthamD-xy9hu 2 ай бұрын

@@paphitisn My pleasure sir!

@suryakantthakur1879 2 ай бұрын

Excellent...

@deepankararya005 13 күн бұрын

Thanks !

@mansoorhassan6638 8 ай бұрын

very nice..

@evasco1979 2 күн бұрын

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

@shaunbradby676 3 ай бұрын

perfect thanks for that...

@theforce3810 4 ай бұрын

Just Fantastic !!

@paphitisn 4 ай бұрын

Thanks for your comment

@theforce3810 4 ай бұрын

@@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 4 ай бұрын

@@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 4 ай бұрын

@@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 4 ай бұрын

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

@phillic004 11 ай бұрын

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 11 ай бұрын

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.

@dr.suryaprakashsharma5464 3 ай бұрын

nice explaination

@paphitisn 3 ай бұрын

Thanks

@paphitisn 3 ай бұрын

Thanks

@neremoli4990 3 ай бұрын

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

@lifeonly1 7 ай бұрын

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

@paphitisn 7 ай бұрын

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

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

@morganhill4601 3 ай бұрын

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 3 ай бұрын

Check this out kzfaq.info/get/bejne/hLybYLt7xJqvaKM.html

@GowthamD-xy9hu 2 ай бұрын

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 2 ай бұрын

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

@GowthamD-xy9hu 2 ай бұрын

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

@SumeetPatil-zb6xl 28 күн бұрын

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 25 күн бұрын

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.

@user-fd3tb6py6x 8 ай бұрын

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

@user-fq7pk5tn7o 2 ай бұрын

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?

@Estefania817 2 ай бұрын

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 2 ай бұрын

I am not a mac user but you need to make sure that you have the complete path inserted.

@videoawesomenessbylisa5803 8 ай бұрын

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 8 ай бұрын

i think you are referring to a different video, this one: kzfaq.info/get/bejne/hLybYLt7xJqvaKM.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

@DavidKClements 9 күн бұрын

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 9 күн бұрын

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 8 күн бұрын

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

@m.murtazamadha962 9 ай бұрын

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

@navigatorsfieldsupportcent9548 5 ай бұрын

command-fn-F9 worked for me

@oscarwilliams2023 Жыл бұрын

hey, it's me again

@robmendell6338 3 ай бұрын

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

@user-io3it2dz6c 5 ай бұрын

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

@paphitisn 5 ай бұрын

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 4 ай бұрын

I also got this error

@paphitisn 4 ай бұрын

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 4 ай бұрын

@@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 3 ай бұрын

Getting same error doing everything same

@user-rj8kl5mq3n 5 ай бұрын

control f9 doesn't work on my word :(

@paphitisn 5 ай бұрын

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

@ShahBusinessPoint 3 ай бұрын

Shift f9

@gauravgupta5616 3 ай бұрын

Photo sare same in all document

@paphitisn 3 ай бұрын

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

@gauravgupta5616 3 ай бұрын

@@paphitisn i already checked my xl file

@wongcheongway5810 7 ай бұрын

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 7 ай бұрын

not too sure what you mean.

@NYSEEDGrant 7 ай бұрын

I have the same problem

@wongcheongway5810 7 ай бұрын

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 7 ай бұрын

@@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 6 ай бұрын

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