Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
@kylepeters2148
5 ай бұрын
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!
@ChrisCiccone-c7g
Ай бұрын
This workflow is very helpful; Is it possible to attach multiple files onto one email using this same flow?
@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!
@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
@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!
@gukidoki
2 ай бұрын
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!!
@YVRCanada
2 жыл бұрын
Wow...amazing! No VBA and no add-ins! Thanks, Leila!
@shatakshikapoor8710
3 жыл бұрын
Hi Ma'am, what a wonderful coincidence, I just logged into KZitem 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 😁
@bulususaiaravindsarma9617
9 ай бұрын
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.
@semiheser
Жыл бұрын
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
Жыл бұрын
Hi @semiheser did you find a way to remove the limit? @leila could you suggest a way out?
@jakehenry501
Жыл бұрын
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
Жыл бұрын
@@jakehenry501 let me know if you find a way, mine is around 300 but still
@beeelemental
11 ай бұрын
@@rolandoamirmirabalhinojosa7091 wow how you can do that..? i still stuck with the limit = 20
@teawithe6933
10 ай бұрын
Think someone put a comment about this on another video on power automate mail merge - the video with Kevin stratvert! @@rolandoamirmirabalhinojosa7091
@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!
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.
@somaiyamilind
2 жыл бұрын
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.
@Srivatsa224
Жыл бұрын
Hey, did you get the answer for this by any chance? 😅
@Srivatsa224
Жыл бұрын
Please let me know the solution for the same if you've already got the answer.
@gaosun668
Жыл бұрын
+1
@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!
@deepermindfulness
2 жыл бұрын
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.
@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.
@andresc01
3 жыл бұрын
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!
@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!
@barakabelle6923
2 ай бұрын
Thank you, your videos have changed my career.
@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
6 ай бұрын
This is absolutely a game changer 🙌. Best video I've watched on KZitem ❤
@ShafiqulIslam-um5nq
4 ай бұрын
Thank you for this great video. Made a big difference for me. The only problem I am having is when it sends the pdf and I open the pdf in email, I get it blank. Please help!!
@lukecarter7035
4 ай бұрын
me too! Let me know if you solved the blank pdf issue
@leomccormackaucklandnz4637
2 ай бұрын
Fantastic, just what I needed to complete a more complex mail merge and emailing individualised attachments. Keep the good work up.
@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!
@njengasheba
2 жыл бұрын
Thank you! Worked for me. I used it to send 400 certificates to different trainees.
@nikhilangolkar4540
2 ай бұрын
Hi, this is really helpful, can you tell me how can I attach multiple attachments using same method? Please this is what i was searching for a while. Thank You.
@davidlevesque4277
2 ай бұрын
Hi Leila, this walk through was very helpful and extremely detail oriented! One question, how would I adjust the excel sheet to include multiple email addresses/attachments? Do you need to add a colon or comma what is coding? Thank you!
@davidlevesque4277
2 ай бұрын
Can anyone assist on this?
@anshumanchapheker7664
2 жыл бұрын
Genius. This just saved my day & I learnt something new. Thank you for explaining this in simple words.
@LukeShaw474
Жыл бұрын
Thank you Leila, this process has just saved me a day worth of work!
@damrupunjabi684
3 жыл бұрын
Leila always fulfils all my dreams!
@SimplyMoi91
3 жыл бұрын
Thank you, lifesaver from mundane, time consuming tasks. Always great content!
@LeilaGharani
3 жыл бұрын
Thank you, Martha!
@mohammedshoaib4144
3 жыл бұрын
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 😊
@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.
@tsamt4889
Жыл бұрын
Hi Leila, amazing and easy to follow tutorial as always. From the comments I read, it seems I'm not the only one who would like to create the same flow for files saved in Sharepoint instead of One Drive. I tried following the same idea but maybe not selecting the right action for Sharepoint. Would it be possible to create a similar tutorial for Sharepoint please......
@mauriceprice4211
2 жыл бұрын
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
2 жыл бұрын
Happy it was helpful, Maurice!
@anthonyswanink1318
2 жыл бұрын
Thanks for the video, it has been very helpful. You mention that it is possible to send more than one attachment but I haven't been able to figure out how to make this work - for example a unique file to each recipient and another attachment that is the same for each user - this could be a help file of some sort. Could you explain how to add this second attachment?
@50bravo
2 жыл бұрын
Hi Leila, could you please take us through this but with Sharepoint instead of a onedrive folder? Thanks!
@emanuelegiglio4676
3 жыл бұрын
Hi Leila Thanks for the great tutorial. I marginally tailored the flow but I’m stuck on two points. 1) How to attach a second document; for example a fixed one across all emails 2) Have a failed message for unsuccessful lines. Could you please expand on the topic? Thanks Emanuele
@ey6678
Жыл бұрын
Hey, did you get the answer for this by any chance? 😅
@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
@jonhawkins1990
2 жыл бұрын
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.
@arunprasathgm
8 ай бұрын
Excellent. Thank you so much for your crisp and clear explanation.
@LeilaGharani
8 ай бұрын
You're very welcome!
@6nilu
Жыл бұрын
Thanks a lot Leila mam, it made our task very easy for sending attachments in bulk using power Automate
@mariuslien4558
2 ай бұрын
Exactly what I needed, except I need to do it with an excel spreadsheet and pdf files residing on a sharepoint folder rather than OneDrive. What will the main differences be in terms of actions and dynamic inputs (i see they are a bit different than OneDrive examples in the video) - again thanks a bunch for the video!
@hhbadarin
Жыл бұрын
Works perfectly, Thanks Leila!
@enricaluraschi8218
3 ай бұрын
Grazie mille form Italy! You really are a life saver.
@LeilaGharani
3 ай бұрын
Happy to help!
@santanubiswas5647
3 жыл бұрын
Just started using power automate. Must say it's very useful and neat.
@LeilaGharani
3 жыл бұрын
It really is!
@bagusabdani
Жыл бұрын
Thank you, Leila. It's really helpful. You explained beautifully.
@LeilaGharani
Жыл бұрын
You're welcome 😊
@tifouraamina1761
3 жыл бұрын
Great tips as always, thank you Leila 🤗
@muzaffar700
10 ай бұрын
Thankyou so much Leila. This another excellent video like all other. Great work.
@oseanosteopathiceuropeanac2968
Жыл бұрын
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!
@jensenallenco4411
9 күн бұрын
did you find any alternative?
@jhollow33
Жыл бұрын
Brick wall may have been eliminated. You’re the best!
@zer0w500
5 ай бұрын
Thanks, this worked really interesting how these triggers work.
@lorenzoarodriguez6048
3 жыл бұрын
This is new to me and I will try it as I send many mail merged documents every year.
@ym6394
3 жыл бұрын
Thank you for your time, dedication and love of the subject🙏🙏🙏
@james70thomas
7 ай бұрын
❤ Great job Leila, wonderful tutorial, worked for me. Thank you very much
@LeilaGharani
7 ай бұрын
Great to hear!
@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.
@cdyard1
3 жыл бұрын
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.
@LeilaGharani
3 жыл бұрын
Oh, so glad you like the content, Claire.
@ivanbarrera3
7 ай бұрын
Hi Leila! Could you please show an example using google drive instead of onedrive? Thanks!
@trishstreet5776
2 жыл бұрын
Been struggling all week long! Such a great solution and wonderful tutorial, thank you!
@grisglen
3 жыл бұрын
Amazing! This is going to save so much time on my day to day work
@aufarasad9720
3 жыл бұрын
Leila, from the bottom of my heart, Thank you! Liked and Subscribed.
@LeilaGharani
3 жыл бұрын
Great! Glad to have you aboard!
@gaosun668
Жыл бұрын
Thanks for posting. What if we want to attach the multiple attachments to personal recipient?
@omkardeshpande29
3 жыл бұрын
Amazing very nicely explained and saved hours of manual work... Thanks a ton.
@damrupunjabi684
3 жыл бұрын
Your last 10 videos were amazing!
@LeilaGharani
3 жыл бұрын
Oh thank you!
@saradhee
3 жыл бұрын
Awesome Leila! Please post more videos like this for sending emails on specific date!
@FariborzZaigar
4 ай бұрын
Hi Thanks for the video. It is excellent. However, the flow addin works only in excel desktop app and not in excel for web. Is there anything you can do to resolve the same. Thanks in advance.
@torokrab88
Жыл бұрын
Thank you for you sharing, That can help me to more productivity
@HarishGarg-om8il
4 ай бұрын
As you asked for an Idea: 1. asset request form: I have a MS-Form having field EmpID, RequestType, and Item list and now As user clicks on Submit button it should check first that entered email id in form is exist in masterdata set placed in somewhere in excelTable with column EmpID listed. and it it matches than send email to manager1 to approve and if this is approve than it should send email to Manager2 and IF in first step Email ID does not exist in dataset it should send an email or notify on form.
@jenglish1986
6 ай бұрын
Great just what I needed. This works perfect for sending insurance certificates.
@gargimitra2010
Жыл бұрын
Hi, your tutorials are really wonderful. Thanks for sharing the same.
@schandro101
2 жыл бұрын
Hi Leila, thank you for another game-changer video!
@LeilaGharani
2 жыл бұрын
My pleasure!
@LynnlynninVA
2 жыл бұрын
This is perfect! Just what I was looking for.
@dwiwijayani4179
Жыл бұрын
Hii Laila, what if I cannot add FLOW on my Excel, if there another way?
@christyimperial7302
2 жыл бұрын
This is superb! Thank you for this video, this is very helpful
@denzdvd3847
2 жыл бұрын
Hi, Leila. you have been part of my journey in my data analytics especially during the time when I was starting 4 years ago, when I created a dashboard in excel. I am hoping you can help me, all of us on automating creation of a pdf report from power bi dashboard for each value of a slicer in power bi desktop. that is, each pdf is different for each slicer value.
@ramonmendes_bi
3 жыл бұрын
Leila thanks for sharing this video! I was looking exactly for this example!
@orik777
2 жыл бұрын
Excellent Tutorial. Thank you!!
@shaymaabulfatih9663
3 жыл бұрын
Hi Leila, I came across your KZitem 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.
@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..
@irfansayyed7702
Жыл бұрын
If the attachment file name is numerical then how to verify? Suppose I want send invoices to different vendors then how to match files with email??
@MultiAilove
Ай бұрын
Leila, Thank you. But why I can't generate the first name? it has shown blank for the dynamic content?
@GerhardSteyn-pn6gg
4 ай бұрын
@leilaGharani - Thank you so much for this video, one question though, is there a way you can run around 400 of these? Any additional "steps" to consider before sending? I noticed it only sent the first 20 then I realized there was a limit of 20 and I adjusted the settings on "List files in folder" action and set pagination to on and threshold to 1000. Perhaps a better way of doing it is to pause after every send? Your guidance is much appreciated please?
@usmandodhy3984
6 ай бұрын
Thank you! It was super helpful.👍
@faisalkarim4277
3 жыл бұрын
Today you look stunning. And thanks for new tips. Is excellent.
@chris_thornborrow
Жыл бұрын
Leila , saving lives since , well, forever.
@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?
@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
@RyanCooley-ck4dq
Жыл бұрын
Thank you so so much! Extremely helpful!
@azashukri5322
3 жыл бұрын
You certainly delivered. Thank you Leila.
@LeilaGharani
3 жыл бұрын
You’re welcome 😊
@alejandrawitherspoon7887
Жыл бұрын
Hi Leila! Thank you so much for posting this. This is going to make my life SO much easier! one question though... how do I embed images into the body of the email? I want to add my company's logo at the end of the email, but I don't know how. Thanks :)
@pranavsalvi8338
Жыл бұрын
Hello, I can't find the Microsoft Flow add in. Is that discontinued?
@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!
@rchong3289
3 жыл бұрын
Great video indeed. How to send multiple attachment ? Can a cell a comma separated attachment file name (or semi comma) and then apply a sub for each loop to it ? Is this possible ? Thanks
@tsvetelinalalova9036
10 ай бұрын
Hi Leila, I would like to thank you for the great video lesson. It helps me a lot - I use it to create a flow for sending emails to managers in the company regarding the performance management process. I success. How can I attach the second file? It has the same structured flow as the second file, which is static - the same name and content. Both files are in Excel format.
@extensionesparachrome5982
3 жыл бұрын
Gracias por este maravilloso tutorial, te amo Leila
@thegaminglearning
3 жыл бұрын
Thank you, Leila. I will definitely try to integrate this way for my project. You really are a life saver.
@rozitabintitalib5215
2 жыл бұрын
Love this. Great content Leila. I would love to try this out in my job.
@vjlo
8 ай бұрын
Hi Leila, thank you so much for the tutorial! I managed to send out 30+ emails with attachments in split seconds! Just one thing, not all emails were registered in my Sent folder.. Do you happen to know why?
Пікірлер: 635