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!
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!
@@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
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.
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.
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
Think someone put a comment about this on another video on power automate mail merge - the video with Kevin stratvert! @@rolandoamirmirabalhinojosa7091
This is what I've been looking for almost a week! I needed in urgent, almost gave up by doing it in traditional way instead of with attachment, and luckily I found yours. Thanks a lot, Leila!!
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.
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!
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.
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!
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.
@@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!
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
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!
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.
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.
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.
Hi Leila, amazing video! Thanks for posting. What if we want to attach the multiple attachments to a single recipient? A video on how to create an array or something similar which enables to send multiple attachments will make things more easier. Please post it soon.
Unfortunately, the power automate didn't wanted to make the connection with outlook so I couldn't finish this mail merge this way. Nevertheless, this tutorial is great and everything else was functioning. I've leraned from this channel a lot until now. The best two things I learned were how to change a value in a cell for a whole sheet, that power automate exists and that there is Microsoft To Do. :) Thank you!
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! 😊👍
Looks like I'll need to create a special "Leila Gharani" OneNote notebook: so many fantastic courses, videos and articles! So much to learn. Better than anything the TV has to offer.
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 :)
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
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!
I am really impressed with your ability to deliver concepts with clarity...Great Job Leila !
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!
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 :)
Most welcome, Tyler.
@@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
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.
I'm always amazed at what i learn on this channel.. i had no idea excel can do these things
Glad to hear that!
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.
Hi @semiheser did you find a way to remove the limit? @leila could you suggest a way out?
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
@@jakehenry501 let me know if you find a way, mine is around 300 but still
@@rolandoamirmirabalhinojosa7091 wow how you can do that..? i still stuck with the limit = 20
Think someone put a comment about this on another video on power automate mail merge - the video with Kevin stratvert! @@rolandoamirmirabalhinojosa7091
Wow...amazing! No VBA and no add-ins! Thanks, Leila!
Hi Ma'am, what a wonderful coincidence, I just logged into UA-cam to learn this and it is the first thing available in my subscriptions.
Wonderful! Hope it will be helpful.
@@LeilaGharani It is extremely helpful. I've recommended your channel to all my colleagues.
Google reads minds now too 😁
This is what I've been looking for almost a week! I needed in urgent, almost gave up by doing it in traditional way instead of with attachment, and luckily I found yours. Thanks a lot, Leila!!
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.
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!
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.
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!
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.
@@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!
@@fairlymoon448 ua-cam.com/video/KLosq-mccoI/v-deo.html
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.
Excellent tutorial. Power Automate is a program that all of us must know in depth. Thank you Leila.
It really is a power tool.
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
Happy it was helpful, Maurice!
Fantastic, just what I needed to complete a more complex mail merge and emailing individualised attachments. Keep the good work up.
This is absolutely a game changer 🙌. Best video I've watched on UA-cam ❤
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.
Happy to help!
Wish I could give this 100 thumbs up. This is going to save me hours each month. Thank you.
You're most welcome, Craig!
This tutorial totally changed my work life today. I love your videos; great delivery and easy to follow. Thank you so much! 🌟🌟🌟🌟🌟
Glad it was helpful, Medina!
Thank you Leila, this process has just saved me a day worth of work!
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!
Thank you for sharing this!
Genius. This just saved my day & I learnt something new. Thank you for explaining this in simple words.
Thank you, lifesaver from mundane, time consuming tasks. Always great content!
Thank you, Martha!
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.
Leila always fulfils all my dreams!
Thank you, your videos have changed my career.
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 😊
Thank you! Worked for me. I used it to send 400 certificates to different trainees.
Brick wall may have been eliminated. You’re the best!
Great tips as always, thank you Leila 🤗
Thankyou so much Leila. This another excellent video like all other. Great work.
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.
Excellent. Thank you so much for your crisp and clear explanation.
You're very welcome!
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.
That's a great idea!
Can you make a video on this flow
Awesome Leila! Please post more videos like this for sending emails on specific date!
Been struggling all week long! Such a great solution and wonderful tutorial, thank you!
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 😅
Glad to hear that, Gerard.
This is perfect! Just what I was looking for.
Hi, your tutorials are really wonderful. Thanks for sharing the same.
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..
Power Automate is a really useful tool!
It sure is! Really a power tool.
Thank you, Leila. It's really helpful. You explained beautifully.
You're welcome 😊
Your last 10 videos were amazing!
Oh thank you!
Leila, from the bottom of my heart, Thank you! Liked and Subscribed.
Great! Glad to have you aboard!
Works perfectly, Thanks Leila!
Amazing! This is going to save so much time on my day to day work
Leila , saving lives since , well, forever.
Hi Leila, thank you for another game-changer video!
My pleasure!
Just started using power automate. Must say it's very useful and neat.
It really is!
Hi Leila, amazing video! Thanks for posting. What if we want to attach the multiple attachments to a single recipient? A video on how to create an array or something similar which enables to send multiple attachments will make things more easier. Please post it soon.
Hey, did you get the answer for this by any chance? 😅
Please let me know the solution for the same if you've already got the answer.
+1
Thank you for your time, dedication and love of the subject🙏🙏🙏
Love this. Great content Leila. I would love to try this out in my job.
Leila thanks for sharing this video!
I was looking exactly for this example!
Excellent Tutorial. Thank you!!
This is superb! Thank you for this video, this is very helpful
Thank you so so much! Extremely helpful!
Thanks a lot Leila mam, it made our task very easy for sending attachments in bulk using power Automate
This workflow is very helpful; Is it possible to attach multiple files onto one email using this same flow?
Amazing very nicely explained and saved hours of manual work... Thanks a ton.
Unfortunately, the power automate didn't wanted to make the connection with outlook so I couldn't finish this mail merge this way. Nevertheless, this tutorial is great and everything else was functioning. I've leraned from this channel a lot until now. The best two things I learned were how to change a value in a cell for a whole sheet, that power automate exists and that there is Microsoft To Do. :) Thank you!
did you find any alternative?
❤ Great job Leila, wonderful tutorial, worked for me. Thank you very much
Great to hear!
Thanks, this worked really interesting how these triggers work.
Thanks Leila. Always interesting tips from you :)) Thumbs up!!
Thank you! 😃
I was doing it through macros and now I find this method very interesting.. cheers to Leila Baji...
Glad you liked it.
Thank you for you sharing, That can help me to more productivity
Time saver! Thank you so much!!
Great just what I needed. This works perfect for sending insurance certificates.
I like your information that you share with us so freeely
It's my pleasure.
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! 😊👍
Power Automate really is a power tool :)
Can you help me because i cannot install Microsoft flow for excel
Today you look stunning. And thanks for new tips. Is excellent.
Thank you, Leila. I will definitely try to integrate this way for my project. You really are a life saver.
I was doing this from VBA, but this is a game changer :)
Hope it will come in handy for you, Marko.
You certainly delivered. Thank you Leila.
You’re welcome 😊
Thank you! It was super helpful.👍
This is new to me and I will try it as I send many mail merged documents every year.
Looks like I'll need to create a special "Leila Gharani" OneNote notebook: so many fantastic courses, videos and articles! So much to learn. Better than anything the TV has to offer.
Oh, so glad you like the content, Claire.
Get out my mind ! it's exactly what I was looking for :)
Haha, glad the timing worked out :)
Gracias por este maravilloso tutorial, te amo Leila
This is the best thing ever!!! Thank you so much!
My pleasure :)
Powerful tool and great explanation as always!
Thank you!
Indeed a smart way. Thanks for the share.
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 :)
Sounds great, Andy!
Excellent work Leila I will try and share my experience
Hi Leila,your tutorial are so help pls make more videos on power automate
nice and beautiful example from excel
You are a life saver
Grazie mille form Italy! You really are a life saver.
Happy to help!
Awesome tutorials
Thanks a lot Leila. You answered my query.
It will be of great help to me.
You're welcome 😊
Brilliant! Thank you so much!
very nice, helpful.. Many thanks
Perfect - saves so much time :)
Another great video!
Thank you!
Thanks. Really helpful
i know u gonna be life saver
Happy to help 😁
It would be great to see how we can make multiple custom pdfs and send them as attachments :)1
Please let me know if you are able to send multiple custom pdf