How to Use Power Automate to Send Emails from Excel with PERSONAL Attachments

Рет қаралды 382,250

Күн бұрын

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
In this tutorial I'll show you how you can do a mail merge with pdf attachments. We'll send personalized emails to multiple recipients with their own attachment. Best part is, we'll be sending the emails directly from Excel - without VBA, AND no Add-Ins required!
We'll use Power Automate to send each person a customized email message together with their respective attachment. We can trigger the event directly from Excel. Because we setup a flow to get this done, we can define bcc, cc, the reply to email address and a lot more options. You can also send multiple attachments with Power Automate.
🎥 What You'll Learn:
- Setting Up Excel File: Organize your data in Excel with names, emails, and corresponding file names.
- Using Power Automate: Navigate Power Automate to create a flow that triggers from Excel.
- Selecting Data in Excel: Understand how to select rows in Excel to initiate the flow.
- Customizing the Flow: Tailor the flow to loop through files, match file names, and send emails.
- Sending Personalized Emails: Configure Power Automate to send custom emails with the correct attachments.
- Testing and Execution: Learn how to test and execute the flow successfully.
🌟 Why Watch This Video:
- Perfect for Excel users who regularly communicate with multiple contacts.
- Essential for professionals seeking efficient ways to automate repetitive tasks.
- Great for those who want to leverage Power Automate for Excel-based tasks.
00:00 Excel Mail Merge With Attachments
01:46 Create Instant Cloud Flow in Power Automate
03:02 Setup a Loop to get files in a Folder
05:58 Prepare a Custom Email with Dynamic Content
08:03 Run Flow to Send Emails With PDF Attachments
10:20 Wrap Up
LINKS to related videos:
► Power Automate Beginner's Guide: • Learn to Use Power Aut...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel #powerautomate

Пікірлер: 605

@LeilaGharani 5 ай бұрын

Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter

@kylepeters2148 2 ай бұрын

I cannot thank you enough for this video - this is probably the 10th video I have watched to try this exact thing and none of the others made any sense or provided the steps clearly enough to replicate. You have saved me hours of busy work every month. Great video - thank you!

@sumittrivedi3759 3 жыл бұрын

I am really impressed with your ability to deliver concepts with clarity...Great Job Leila !

@S040306 Жыл бұрын

Hi Leila, this video has been a game changer for me and my team. We had successfully delivered accurate year end statements for all employees. The whole process was touchless and seamless. We are super grateful for thinking of such a user scenario and coming up with an amazing video. Thank you!

@andresc01 2 жыл бұрын

Excellent Tutorial. I had to send 39 emails all with different attachments and this saved me a lot of time. I did not even test my flow and it worked in the first run (no recommended). Thank you!

@TylerStanczak 3 жыл бұрын

Now this is a game changer. I don’t think I was able to figure this out ever with mail merges so thank you for sharing this :)

@LeilaGharani 3 жыл бұрын

Most welcome, Tyler.

@staceymorris3611 2 жыл бұрын

@@LeilaGharani Hi I was wondering if I want to send emails with CC how do I include this in excel, if I want to send two different pdf attachments can I just create another column. Can I have it 'rescheduled' but I have to actually hit send incised there are weeks I don't need to send reports.. I'm really nervous about sending incorrect reports to wrong clients re;confidentiality but so tired of typing and sending 15 emails each week.. has to be an easier solution? Would appreciate any help p.s have referred to your videos re: data analysis and power bi very useful. Thanks again

@YVRCanada 2 жыл бұрын

Wow...amazing! No VBA and no add-ins! Thanks, Leila!

@mohammedshoaib4144 2 жыл бұрын

Thank you leila, was fed up of using add in from external parties and now this changes things. The way you explained made it much easier, Thank you 😊

@josecarlosconejo5724 3 жыл бұрын

Hi Leila, I am using Power Automate to run an automatic approval flow. I get notified by email whenever approvers approve or reject. Apart from getting email evidence of approval, Power Automate keeps record of approvals as well. Approval flows are a specific chapter within Power Automate with lots of possibilities and combinations. There are many things you can do without writing a single line of code, but if you know some JSON basics you can become the Power Automate hero of your company (this is one of my future learning activities). Great video 👍 Thanks for sharing.

@fairlymoon448 3 жыл бұрын

This is genius!!! I've been waiting for something like this. It looks a bit complicated to set up but once it's there it will be super useful. Thank you!!!!! When you're emailing 100+ students with different files. Heck yeah!

@enuarurutini Жыл бұрын

Have you figured out how to leverage Power Automate to send your students their individual files with Power Automate? I ran into a wall with my Flow as per the video, and wanted to see how you got on? In my case, i've got 156x attachments to send, but this Flow can't handle so many.

@fairlymoon448 Жыл бұрын

@@enuarurutini Sadly no.. I really wanted to try however my organisation has disallowed the microsoft store and addons so unfortunately couldn't even install it. Requisition attempts also failed because everyone is a dinosaur. Am sadly stuck with using an old macro which doesn't allow to differentiate different attachments but at least lets me open 20+ individual emails already addressed and subjected... i think there's a method to add different attachments per email as well but my VBA isn't good enough to alter it unfortunately... D: i hope you find something though!

@orik777 Жыл бұрын

@@fairlymoon448 kzfaq.info/get/bejne/gbKfptRe0snHn30.html

@coffeecuppepsi 3 жыл бұрын

I'm always amazed at what i learn on this channel.. i had no idea excel can do these things

@LeilaGharani 3 жыл бұрын

Glad to hear that!

@rturri2000 3 жыл бұрын

Thank you Leila!!! I absolutely love your Microsoft videos. You've taught me so much about the Office programs which has helped me excel in my career.

@LeilaGharani 3 жыл бұрын

Happy to help!

@trishstreet5776 2 жыл бұрын

Been struggling all week long! Such a great solution and wonderful tutorial, thank you!

@thegaminglearning 3 жыл бұрын

Thank you, Leila. I will definitely try to integrate this way for my project. You really are a life saver.

@medinatrent-borja8939 Жыл бұрын

This tutorial totally changed my work life today. I love your videos; great delivery and easy to follow. Thank you so much! 🌟🌟🌟🌟🌟

@LeilaGharani Жыл бұрын

Glad it was helpful, Medina!

@damrupunjabi684 3 жыл бұрын

Leila always fulfils all my dreams!

@ym6394 3 жыл бұрын

Thank you for your time, dedication and love of the subject🙏🙏🙏

@SimplyMoi91 3 жыл бұрын

Thank you, lifesaver from mundane, time consuming tasks. Always great content!

@LeilaGharani 3 жыл бұрын

Thank you, Martha!

@anshumanchapheker7664 Жыл бұрын

Genius. This just saved my day & I learnt something new. Thank you for explaining this in simple words.

@IvanCortinas_ES 3 жыл бұрын

Excellent tutorial. Power Automate is a program that all of us must know in depth. Thank you Leila.

@LeilaGharani 3 жыл бұрын

It really is a power tool.

@tifouraamina1761 3 жыл бұрын

Great tips as always, thank you Leila 🤗

@mauriceprice4211 Жыл бұрын

Hi Leila, this has just saved me a mountain of work. No need for add-ins and I could just follow along with the tutorial to send out my custom email with attachments...heaven! So grateful. Maurice

@LeilaGharani Жыл бұрын

Happy it was helpful, Maurice!

@omkardeshpande29 2 жыл бұрын

Amazing very nicely explained and saved hours of manual work... Thanks a ton.

@hhbadarin Жыл бұрын

Works perfectly, Thanks Leila!

@LynnlynninVA 2 жыл бұрын

This is perfect! Just what I was looking for.

@bulususaiaravindsarma9617 6 ай бұрын

This worked for me. It's great. Thanks a ton for this tutorial. Every month I am supposed to send data tracker to my boss. Now using this, I will no longer have to sit an draft a mail or find for attachments, and simply use the power automate run flow to send the mail at just one click.

@saradhee 3 жыл бұрын

Awesome Leila! Please post more videos like this for sending emails on specific date!

@lawsimon8972 Жыл бұрын

I need to send attachment and similar email content to many many customers using excel, and I found it very useful in my task recently.

@StudyTips4U 3 жыл бұрын

Useful video! Love Power Automate. I am using it to give exam feedback by sending individual marked exam scripts to my student (>150) via Power Automate with one click.

@Joshiya949 3 ай бұрын

This is absolutely a game changer 🙌. Best video I've watched on KZfaq ❤

@shatakshikapoor8710 3 жыл бұрын

Hi Ma'am, what a wonderful coincidence, I just logged into KZfaq to learn this and it is the first thing available in my subscriptions.

@LeilaGharani 3 жыл бұрын

Wonderful! Hope it will be helpful.

@shatakshikapoor8710 3 жыл бұрын

@@LeilaGharani It is extremely helpful. I've recommended your channel to all my colleagues.

@MrJamesguy1 3 жыл бұрын

Google reads minds now too 😁

@LukeShaw474 11 ай бұрын

Thank you Leila, this process has just saved me a day worth of work!

@jonhawkins1990 Жыл бұрын

Hi L. I think that was good. The application that I have is automating a complex quoting system using Excel - this part really does speed stuff up. I need to set it up and dedicate some time do so - convinced it will be worth it - It is the kind of thing that will be a worthwhile slog - I think. Thanks for doing this.

@deepermindfulness Жыл бұрын

really not sure what to say. still letting this all sink in. been looking for a way of scheduling a number of emails in advance and it seems it is all there in PowerAutomate. This could be a game changer for how we use office. thank you. very much appreciate this.

@KimHongTan 3 жыл бұрын

Great video, thanks Leila! I use Power Automate to automatically send out the calendar invitation to my participants upon successful registration of my training. It just saves me tons of time.

@LeilaGharani 3 жыл бұрын

That's a great idea!

@6nilu Жыл бұрын

Can you make a video on this flow

@ramonmendes_bi 2 жыл бұрын

Leila thanks for sharing this video! I was looking exactly for this example!

@wendrasetiawan4916 3 жыл бұрын

Hi Leila. Thank you for your video, this is actually that one I need.. Hope you doing great and waiting for more of your videos.. Regards..

@orik777 2 жыл бұрын

Excellent Tutorial. Thank you!!

@grisglen 2 жыл бұрын

Amazing! This is going to save so much time on my day to day work

@gargimitra2010 Жыл бұрын

Hi, your tutorials are really wonderful. Thanks for sharing the same.

@rozitabintitalib5215 2 жыл бұрын

Love this. Great content Leila. I would love to try this out in my job.

@RyanCooley-ck4dq Жыл бұрын

Thank you so so much! Extremely helpful!

@usmandodhy3984 3 ай бұрын

Thank you! It was super helpful.👍

@gremmariealmajose4585 2 жыл бұрын

Time saver! Thank you so much!!

@azashukri5322 3 жыл бұрын

You certainly delivered. Thank you Leila.

@LeilaGharani 3 жыл бұрын

You’re welcome 😊

@zer0w500 2 ай бұрын

Thanks, this worked really interesting how these triggers work.

@muzaffar700 7 ай бұрын

Thankyou so much Leila. This another excellent video like all other. Great work.

@helenasvensson6747 2 жыл бұрын

Brilliant! Thank you so much!

@christyimperial7302 2 жыл бұрын

This is superb! Thank you for this video, this is very helpful

@njengasheba 2 жыл бұрын

Thank you! Worked for me. I used it to send 400 certificates to different trainees.

@wakelingchicken 3 жыл бұрын

Thanks Leila. I built this with VBA a little while ago, so I look forward to dipping into this video in the near future to check out the PowerAutomate version :)

@LeilaGharani 3 жыл бұрын

Sounds great, Andy!

@gerardhourde6429 3 жыл бұрын

Thank you for your little tutorial on power automate👍 They serve me daily at work and help me a lot. Really very usefull I follow you 😅

@LeilaGharani 3 жыл бұрын

Glad to hear that, Gerard.

@torokrab88 10 ай бұрын

Thank you for you sharing, That can help me to more productivity

@SyedMuzammilMahasanShahi 3 жыл бұрын

Indeed a smart way. Thanks for the share.

@adityapatnaik6079 3 жыл бұрын

this is just amazing !

@shaymaabulfatih9663 3 жыл бұрын

Hi Leila, I came across your KZfaq channel over a year now and have learned a lot from you since then. Thank you for the wonderful content and and style of delivery. You're my number one stop when I want to learn something new in office. This is the first time I learn about Power Automate; it sure seems to be a powerful tool and I can't wait to explore it further and use it at work. Is there a way to automate the creation of the pdf files then send them as attachments? In your video the pdfs were already created.

@damrupunjabi684 3 жыл бұрын

Your last 10 videos were amazing!

@LeilaGharani 3 жыл бұрын

Oh thank you!

@arunprasathgm 5 ай бұрын

Excellent. Thank you so much for your crisp and clear explanation.

@LeilaGharani 5 ай бұрын

You're very welcome!

@danielhutchinson6158 Жыл бұрын

Thank you Leila.

@bagusabdani Жыл бұрын

Thank you, Leila. It's really helpful. You explained beautifully.

@LeilaGharani Жыл бұрын

You're welcome 😊

@extensionesparachrome5982 2 жыл бұрын

Gracias por este maravilloso tutorial, te amo Leila

@edzie_blue897 11 ай бұрын

Thanks for this ❤❤❤

@Thehavemans 3 жыл бұрын

Wish I could give this 100 thumbs up. This is going to save me hours each month. Thank you.

@LeilaGharani 3 жыл бұрын

You're most welcome, Craig!

@vida1719 3 жыл бұрын

Powerful tool and great explanation as always!

@LeilaGharani 3 жыл бұрын

Thank you!

@santanubiswas5647 3 жыл бұрын

Just started using power automate. Must say it's very useful and neat.

@LeilaGharani 3 жыл бұрын

It really is!

@aufarasad9720 3 жыл бұрын

Leila, from the bottom of my heart, Thank you! Liked and Subscribed.

@LeilaGharani 3 жыл бұрын

Great! Glad to have you aboard!

@jo-annalbano5842 Жыл бұрын

Perfect - saves so much time :)

@lorenzoarodriguez6048 3 жыл бұрын

This is new to me and I will try it as I send many mail merged documents every year.

@vinayyaduvanshi 2 жыл бұрын

Thanks. Really helpful

@yulinliu850 3 жыл бұрын

Absolutely brilliant!

@LeilaGharani 3 жыл бұрын

Thank you!

@james70thomas 4 ай бұрын

❤ Great job Leila, wonderful tutorial, worked for me. Thank you very much

@LeilaGharani 4 ай бұрын

Great to hear!

@jaybuddhadev3543 2 жыл бұрын

very nice, helpful.. Many thanks

@KEN_DEN 3 жыл бұрын

I’ve learned a lot from your videos. It has helped with me with my work. Can you please do a video about all the Depreciation Methods ? Thank you very much

@wayneedmondson1065 3 жыл бұрын

Thanks Leila. Always interesting tips from you :)) Thumbs up!!

@LeilaGharani 3 жыл бұрын

Thank you! 😃

@lukecarter7035 Ай бұрын

Amazing. Clear and helpful and it works! This video alone will have massive positive impact on the efficiency of my company. I noticed that I had to turn of the "New Designer" to prevent the end result from sending blank pdfs. Not sure what was causing that, but going to the old designer fixed it. Thanks so much!

@LeilaGharani Ай бұрын

Thank you for sharing this!

@6nilu Жыл бұрын

Thanks a lot Leila mam, it made our task very easy for sending attachments in bulk using power Automate

@TimSheets 3 жыл бұрын

thanks for these power automate videos! I want to like it / use it but wow does it seem daunting!

@taimoorkhan8203 3 жыл бұрын

I was doing it through macros and now I find this method very interesting.. cheers to Leila Baji...

@LeilaGharani 3 жыл бұрын

Glad you liked it.

@faisalkarim4277 3 жыл бұрын

Today you look stunning. And thanks for new tips. Is excellent.

@abdulhamidalhaddadi2255 Ай бұрын

Thank you

@vijayarjunwadkar 3 жыл бұрын

Thanks a lot Leila for this super useful tutorial! How I wished, I had this before few years, where I had to struggle and juggle between multiple tools to get customized attachments! But none the less, now it's so easy! Power Automate is sure to change everything about Office tools, wow! 😊👍

@LeilaGharani 3 жыл бұрын

Power Automate really is a power tool :)

@congtytnhhtmdvsunflowerath5188 Жыл бұрын

Can you help me because i cannot install Microsoft flow for excel

@shifamomin6547 2 жыл бұрын

Hi Leila,your tutorial are so help pls make more videos on power automate

@andrewmoss6449 3 жыл бұрын

Power Automate is a really useful tool!

@LeilaGharani 3 жыл бұрын

It sure is! Really a power tool.

@markomihailovic9169 3 жыл бұрын

I was doing this from VBA, but this is a game changer :)

@LeilaGharani 3 жыл бұрын

Hope it will come in handy for you, Marko.

@enocharthur4322 Жыл бұрын

Awesome tutorials

@chrystalskaggs1140 2 жыл бұрын

I love this! Is there a current video you recommend for adding multiple attachments to each person's email using excel the same way you explained here?

@schandro101 Жыл бұрын

Hi Leila, thank you for another game-changer video!

@LeilaGharani Жыл бұрын

My pleasure!

@robertakwasiadjei8223 3 жыл бұрын

Great Work Leila

@tradekey8435 2 жыл бұрын

Excellent work Leila I will try and share my experience

@singyeeneo7932 2 жыл бұрын

This is the best thing ever!!! Thank you so much!

@LeilaGharani 2 жыл бұрын

My pleasure :)

@semiheser 11 ай бұрын

Hi Leila, thank you for this fantastic tutorial. FOR THE VIEWERS: I found that the limit is 20 for each batch, so try to select (this version only sends to the selected rows) 20 for each set until you complete your whole list. You can see the sent ones in your sent box. I have used an alternative email address to send from, which also worked. (It was a shared inbox) Thank you.

@anjalitiwari5744 10 ай бұрын

Hi @semiheser did you find a way to remove the limit? @leila could you suggest a way out?

@jakehenry501 10 ай бұрын

Looking for a similar answer. I tried to do something similar through share point to see if it could go beyond the limit but failed. I have 1800 emails to send out next week hoping to bypass the loop limit

@rolandoamirmirabalhinojosa7091 10 ай бұрын

@@jakehenry501 let me know if you find a way, mine is around 300 but still

@beeelemental 8 ай бұрын

@@rolandoamirmirabalhinojosa7091 wow how you can do that..? i still stuck with the limit = 20

@teawithe6933 7 ай бұрын

Think someone put a comment about this on another video on power automate mail merge - the video with Kevin stratvert! @@rolandoamirmirabalhinojosa7091