Image Mail Merge Using Excel, Picture Mail Merge, Photo Mail Merge

  Рет қаралды 65,720

Microsoft Office, Adobe Tutorials, FREE WEBSITE

Microsoft Office, Adobe Tutorials, FREE WEBSITE

Күн бұрын

Пікірлер: 36
@ZainaDancer
@ZainaDancer Жыл бұрын
Great video/tutorial! I used to do this stuff in my sleep back in the day, but have forgotten how and a project for a class reunion is coming up (making name badges and doing a memorial tree for grads who have crossed over). I have watched at least 6 other videos on how to make this happen and NONE of them made any sense or enabled me to make this mail merge work! Thank you ! 💙
@StoneridgeBuilders-sh3ee
@StoneridgeBuilders-sh3ee 4 ай бұрын
I also have a reunion, I have the name tag formatted but need to add the photos to each name tag. I need to know what type of file I need to create for the photos.
@ZainaDancer
@ZainaDancer 4 ай бұрын
@@StoneridgeBuilders-sh3ee maybe the content creator will reply and give you different information, but I know when I did mine I basically needed three separate files. First the Word mail merge document, then the Excel file which included all the names and other data, and then the image file for each person. Sounds like you're on the right track, just make sure that your name tag document (the Word file) has the proper coding as described in the video, so when you're ready your merge will go smoothly. You may need to do some tweaking along the way, but that should absolutely work.
@RhondaMitchellRhocks
@RhondaMitchellRhocks 4 ай бұрын
EXACT same for me.
@danwilliams582
@danwilliams582 3 ай бұрын
Thank you very much! I'd hoping to do something very much like this and was trying to figure out how! Now I have a starting point!
@johnh10000
@johnh10000 3 жыл бұрын
Thanks for the pointers, but the extra next's put me off track a bit. But got it sorted. So I can resize the images beforehand, is there a way to determine the manually resized pics? dimmensions.
@gauravmerugu7415
@gauravmerugu7415 Жыл бұрын
After I enter my data and preview, it does not come in the serial order. Example instead of profile 1 profile 2 profile 3, it skips each profile. It shows up as profile 1, profile 3, profile 5. This is on Mac. Either the next record isn't functioning properly or I'm doing it wrong.
@briant6164
@briant6164 Ай бұрын
thx!! saved me a bunch o' time
@PashupatinathMishra1309
@PashupatinathMishra1309 Жыл бұрын
Thanks a lot, buddy I was using mail merge and my images were not populating, Your video helped me to solve the problem.
@niloobolsinlaphathanoo1464
@niloobolsinlaphathanoo1464 Жыл бұрын
You save my life time now !!!
@MathEd-k3b
@MathEd-k3b Жыл бұрын
Thank you! 🙂
@Computrix1000
@Computrix1000 Жыл бұрын
Is there a way to make the image size larger? cuz it's very small i want the size to reach the border of the shape.
@davidconquest2584
@davidconquest2584 4 жыл бұрын
Excellent video! Exactly what I was look for.
@designmines
@designmines 4 жыл бұрын
Thank you!, please share, like, subscribe my channel for more videos : )
@TheCanineMaster
@TheCanineMaster 2 жыл бұрын
My images are coming in too large. Can I create a smaller box inside the cell to have the images pop into it? GREAT video!
@suryalglg5671
@suryalglg5671 2 жыл бұрын
Super nice video
@paxtexas1963
@paxtexas1963 2 жыл бұрын
How does this work for Mac, mac does not give out the location?
@12chachachannel
@12chachachannel Жыл бұрын
Good video!
@ilvdp4ever
@ilvdp4ever 3 жыл бұрын
Thanks for sharing! Does this method work in label template too?
@designmines
@designmines 3 жыл бұрын
Yes, it should be work in any template
@liamzhang94
@liamzhang94 Жыл бұрын
I don’t know why but I got 2 same pictures instead of 1
@jamesonsangel3914
@jamesonsangel3914 2 жыл бұрын
Can this be done in powerpoint too?
@lucianapozzabernardesferre2611
@lucianapozzabernardesferre2611 3 жыл бұрын
Olá. Não entendi o final. Quais teclas são usadas para aparecer as imagens? Obrigada. Hello. I didn't understand the ending. What keys are used to display the images? Thanks.
@designmines
@designmines 3 жыл бұрын
Step - 1: Select all data by pressing (Cntrl + A) Step - 2: Press (F9) Note: If not worked, please save the document and CLOSE IT, then open again and try the step1, 2 above.
@suryalglg5671
@suryalglg5671 2 жыл бұрын
@@designminesnice explain
@alexreinhard2288
@alexreinhard2288 3 жыл бұрын
Mine didn't work at first, but then worked by pressing CTRL + FN + F9
@fabiomoraes
@fabiomoraes 3 жыл бұрын
Doesn't it work for images hosted on the web? I need to do it, but I have to use https links
@designmines
@designmines 3 жыл бұрын
I have not tried using , I am afraid MS word will not syn the web image. You can try and let us know, good luck!
@niloobolsinlaphathanoo1464
@niloobolsinlaphathanoo1464 Жыл бұрын
Ctrl+F9 > Includepicture”…” > Insert = Ctrl+A > F9
@Raviponnuri
@Raviponnuri 3 жыл бұрын
But images are not generated in my case, tried number of times, exactly u did, but image file remaining blank even after pressing f9
@webramesh
@webramesh 3 жыл бұрын
Please try Alt + F9 if its not working, if still not working, please try again you may missed out some steps mentioned in the video. Good Luck!
@Raviponnuri
@Raviponnuri 3 жыл бұрын
@@webramesh sir, tried as shown in the video, but finally image showing like deleted picture symbols
@webramesh
@webramesh 3 жыл бұрын
@@Raviponnuri Ok in that case it might be image link issue, try the image link (path) is correct.
@alexreinhard2288
@alexreinhard2288 3 жыл бұрын
Mine didn't work at first, but then worked by pressing CTRL + FN + F9
@Farhab
@Farhab Жыл бұрын
@@Raviponnuri same here
@this-user
@this-user 7 ай бұрын
4:19 da check ka
Mail Merge PICTURES to documents [step by step]
24:14
Nicos Paphitis
Рет қаралды 36 М.
Insert Image Using Mail Merge From Excel to Word Document
10:42
The Mental Club
Рет қаралды 240 М.
Random Emoji Beatbox Challenge #beatbox #tiktok
00:47
BeatboxJCOP
Рет қаралды 22 МЛН
2 MAGIC SECRETS @denismagicshow @roman_magic
00:32
MasomkaMagic
Рет қаралды 21 МЛН
НАШЛА ДЕНЬГИ🙀@VERONIKAborsch
00:38
МишАня
Рет қаралды 3,3 МЛН
У вас там какие таланты ?😂
00:19
Карина Хафизова
Рет қаралды 13 МЛН
How to Insert Image in Excel Cell
4:41
Excel 10 tutorial
Рет қаралды 39 М.
Add individual images to Mail Merge
7:07
Amir Parmar
Рет қаралды 273 М.
Creating Labels from a list in Excel
3:59
Barb Henderson
Рет қаралды 1,9 МЛН
How To Mail Merge Data And Pictures From Excel To Word?
3:49
ExtendOffice
Рет қаралды 16 М.
Email mail merge: personalized emails using Excel - Word & Outlook
8:19
Mail Merging Barcodes & QR Codes
7:42
Daily Tech Tips with Jason Ishibashi
Рет қаралды 10 М.
Mail Merge from Excel to Microsoft Word
15:03
Technology for Teachers and Students
Рет қаралды 2,7 МЛН
Simplified IncludePicture How-to. Mail merge pictures in Microsoft Word step-by-step
12:04
OnMerge Mail Merging with Word
Рет қаралды 62 М.
Random Emoji Beatbox Challenge #beatbox #tiktok
00:47
BeatboxJCOP
Рет қаралды 22 МЛН