Mail Merge Magic: Insert Images and Clickable Email Addresses from Excel into a Word Document
Рет қаралды 371
In this video, you'll learn how to use the Mailmerge feature of Word to generate documents such as a Product Catalogues, an Employee Directory, a set of Conference Badges or a Real Estate Flyer. Essentially, this technique is perfect for any situation where you need to merge data stored in a Table in Excel (prepared with Power Query) with a Word document layout. This video has the added twist that we need to incorporate multiple images and numerous hyperlinked email or web addresses.
For full details see the timestamps below:
⏱ Timestamps
00:00:00 Introduction
00:01:52 Use Power Query to Import the Employee Data
00:03:08 Use Power Query to Import the Image Filenames
00:10:19 Set up the Merge Document (Including Loading the Images)
🗒 Notes and Resources
Download a copy of the files used in this video: app.box.com/s/sdc9pq3dwa0q020udb7lgy9sxnf03evv
The formulas that I used in the demos:
{INCLUDEPICTURE {IF TRUE {MERGEFIELD "Photo"}} \d}
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: theexceltrainer
Facebook: theexceltrainer
LinkedIn: www.linkedin.com/in/thomasmik
#mailmerge #powerquery #images
@pandamonium9834 2 ай бұрын
Morning Mike-only just squeaked in before midday - this is so interesting and very clever -really liked the demo
@tbaucells1 2 ай бұрын
Mike’s videos are incredibly useful and he presents in a lovely, non-nonsense style so that even complete Excel numpties like me can use what he teaches successfully. Thanks @Mike Thomas
@MikeThomas67 2 ай бұрын
Wow, thank you!
@RenierWessels 2 ай бұрын
Awesome. Thanks Mike. The only thing I would have done differently is searching for the first backslash from the end of the text. That way it's more robust if the folderpath changes. Well done on another great video. Take care!!
@MikeThomas67 2 ай бұрын
Good call!
@mikesison3768 2 ай бұрын
Great Video.. How about if we wanted to send an email with an excel file through Outlook? Can that be another lesson? Thanks.
@MikeThomas67 2 ай бұрын
Yes, absolutely. I'll add it to my list!
@juliepeppitt9253 2 ай бұрын
Can these same processes be done on the Mac?
@MikeThomas67 2 ай бұрын
@juliepeppitt9253 You can do the mailmerge. You can do the import from CSV. You can do the Merge Queries. What can't be done at the moment is loading the names of the files.