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

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

Microsoft Office, Adobe Tutorials, FREE WEBSITE

Күн бұрын

Пікірлер: 36

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

EXACT same for me.

@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 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 Жыл бұрын

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

thx!! saved me a bunch o' time

@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 Жыл бұрын

You save my life time now !!!

@MathEd-k3b Жыл бұрын

Thank you! 🙂

@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 4 жыл бұрын

Excellent video! Exactly what I was look for.

@designmines 4 жыл бұрын

Thank you!, please share, like, subscribe my channel for more videos : )

@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 2 жыл бұрын

Super nice video

@paxtexas1963 2 жыл бұрын

How does this work for Mac, mac does not give out the location?

@12chachachannel Жыл бұрын

Good video!

@ilvdp4ever 3 жыл бұрын

Thanks for sharing! Does this method work in label template too?

@designmines 3 жыл бұрын

Yes, it should be work in any template

@liamzhang94 Жыл бұрын

I don’t know why but I got 2 same pictures instead of 1

@jamesonsangel3914 2 жыл бұрын

Can this be done in powerpoint too?

@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 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 2 жыл бұрын

@@designminesnice explain