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!
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
@@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.
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, 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.
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.
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!
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, 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.
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!
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?
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!
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
Hey Leila - this is a great video, thank you very much for sharing. Is it possible to complete this with multiple attachments, possibly three attachments per recipient email address? I then would like to extend the power automate process to complete record the details into another Excel sheet (unique sheet per user) to record the data sent.
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?
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.
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!!
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
@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?
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.
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 Leila, I needed to multi-select by ctrl-click because the rows of interest were not adjacent. However, I got an error and the flow wasn't triggered either. Is there a workaround? I appreciate your help!
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!
Hi Leila, thanks for this video, it worked for me for onedrive but I was wondering if I can do this Email merge retrieving personalized attachments on SharePoint. thanks
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......
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
Hi, Thanks for this brilliant video. Just one question - is there a way to run the flow without the plug in for excel. it seems like IT has blocked plugins on our work machines
Can't you just copy and paste the signature into the body of the email within Power Automate? I know it's not dynamic but if your signatures don't change then it's fine.
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.
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, this ia very useful. I was able to create my flow. Please assiat, i cannot find th Flow command when i tries to fin in in add ins. I was abpe to see Flow| Instant translator for the enterprise, is it the same? The icon looks different too..
Hi Leila, I had to send out like around 200 emails to our customers with your toroidal & it's great! the first round it worked but second round I needed to just change the pdf file but it's not working. Same file, same "Run" just a different file (also pdf). what could be the reason for this?
Hi Leila, thank you for the video. Can you make a video or let me know "How to send a pivot table from excel in email with body message, table and my default signature" ?
Can you add a different password easily through a similar process to the individual pdf's? I would like to add a column in the Excel file populated with the password. The hope would be to change the pdf's to a password protected sheet before emailing.
Hi Leila, thanks for the video, it is very clear! I have followed all the steps, however the attached file is blank when it is sent and received (if it is a pdf), or it cannot be opened if it is an excel file... Do you know why? Thanks again!
@@lukecarter7035 Yes! (thanks to @ekarim2020). I hope I can be able to explain how: Edit your Flow, go to Send an Email section, then to Attachments and make sure there are not quotes around the values for the ContentBytes. (The word ContentBytes should appear between quotes, but the word File Content shouldn’t. Is should look like this: [ { "Name": "name", "ContentBytes": File content } ]
Thank you Leila for this video! I do have a question for you, I'm having a hard time getting my dynamic File Name to match the Display Name of the file in the folder. When I try to run the flow, I get an output error of 'false'. Can you please help me?? I really appreciate it :)
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!
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!
I am really impressed with your ability to deliver concepts with clarity...Great Job Leila !
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
Hi Ma'am, what a wonderful coincidence, I just logged into TH-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 😁
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
I'm always amazed at what i learn on this channel.. i had no idea excel can do these things
Glad to hear that!
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.
Wow...amazing! No VBA and no add-ins! Thanks, Leila!
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 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 th-cam.com/video/KLosq-mccoI/w-d-xo.html
This workflow is very helpful; Is it possible to attach multiple files onto one email using this same flow?
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.
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.
Excellent tutorial. Power Automate is a program that all of us must know in depth. Thank you Leila.
It really is a power tool.
This is absolutely a game changer 🙌. Best video I've watched on TH-cam ❤
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!
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, 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
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.
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!
Can anyone assist on this?
Works perfectly, Thanks Leila!
Thankyou so much Leila. This another excellent video like all other. Great work.
Excellent. Thank you so much for your crisp and clear explanation.
You're very welcome!
Hi Leila, could you please take us through this but with Sharepoint instead of a onedrive folder?
Thanks!
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?
Thank you Leila, this process has just saved me a day worth of work!
Thank you, Leila. It's really helpful. You explained beautifully.
You're welcome 😊
Fantastic, just what I needed to complete a more complex mail merge and emailing individualised attachments. Keep the good work up.
Thanks for posting. What if we want to attach the multiple attachments to personal recipient?
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!
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!
Great tips as always, thank you Leila 🤗
Thank you! Worked for me. I used it to send 400 certificates to different trainees.
Leila always fulfils all my dreams!
Hey Leila - this is a great video, thank you very much for sharing. Is it possible to complete this with multiple attachments, possibly three attachments per recipient email address?
I then would like to extend the power automate process to complete record the details into another Excel sheet (unique sheet per user) to record the data sent.
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!
Leila, from the bottom of my heart, Thank you! Liked and Subscribed.
Great! Glad to have you aboard!
Thank you, lifesaver from mundane, time consuming tasks. Always great content!
Thank you, Martha!
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?
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.
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!
Hi Leila, is there a limit to the number of messages /rows to send simultaneously? Thanks
Power Automate is a really useful tool!
It sure is! Really a power tool.
Your last 10 videos were amazing!
Oh thank you!
Hi Leila, thank you for another game-changer video!
My pleasure!
Excellent Tutorial. Thank you!!
❤ Great job Leila, wonderful tutorial, worked for me. Thank you very much
Great to hear!
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!!
me too! Let me know if you solved the blank pdf issue
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
Another great video!
Thank you!
@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?
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.
Thank you, your videos have changed my career.
Thank you so so much! Extremely helpful!
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, Thank you so much for the video shared. Question: How to send email with Sharepoint link
Hi Leila, can we use the signature in the outlook for sending of email?
Hi Leila,
I needed to multi-select by ctrl-click because the rows of interest were not adjacent. However, I got an error and the flow wasn't triggered either. Is there a workaround? I appreciate your help!
Hello, I can't find the Microsoft Flow add in. Is that discontinued?
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!
Hi Leila, thanks for this video, it worked for me for onedrive but I was wondering if I can do this Email merge retrieving personalized attachments on SharePoint. thanks
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......
Exactly what I needed, although my files are in SharePoint folder rather than OneDrive. Thank you always
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
Hey, did you get the answer for this by any chance? 😅
Genius. This just saved my day & I learnt something new. Thank you for explaining this in simple words.
Is the PowerAutomate add-on available on Excel for Mac?
Hii Laila, what if I cannot add FLOW on my Excel, if there another way?
Time saver! Thank you so much!!
I like your information that you share with us so freeely
It's my pleasure.
Hi Thank you very much. is it possible to the same with share point instead of one drive
Just started using power automate. Must say it's very useful and neat.
It really is!
Hi, Thanks for this brilliant video. Just one question - is there a way to run the flow without the plug in for excel. it seems like IT has blocked plugins on our work machines
This is superb! Thank you for this video, this is very helpful
Hi, your tutorials are really wonderful. Thanks for sharing the same.
This is the best thing ever!!! Thank you so much!
My pleasure :)
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 😊
Hi Leila! Could you please show an example using google drive instead of onedrive? Thanks!
This is perfect! Just what I was looking for.
Hi leila , thank you so much for the video. But how to add multiple attachments? I tried adding another condition but it dint work. Please help.
Brick wall may have been eliminated. You’re the best!
Can this be done using a SharePoint list with customer emails (outside of company domain) ?
Hi Leila! This is great. Do you have a video to send a mail merge from an excel table with multiple rows to a single person?
Hi Leala
is there a way to add a signature block to the bulk email process you've outlined here?
Cheers,
John
Can't you just copy and paste the signature into the body of the email within Power Automate? I know it's not dynamic but if your signatures don't change then it's fine.
Thank you! It was super helpful.👍
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??
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.
Leila, Thank you. But why I can't generate the first name? it has shown blank for the dynamic content?
indeed Great Help , but when i use If No button even the expression result is true it is also doing If No command aswell , any thoughts?
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.
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
Hi leila, this ia very useful. I was able to create my flow. Please assiat, i cannot find th Flow command when i tries to fin in in add ins. I was abpe to see Flow| Instant translator for the enterprise, is it the same? The icon looks different too..
Hi Leila, I had to send out like around 200 emails to our customers with your toroidal & it's great! the first round it worked but second round I needed to just change the pdf file but it's not working. Same file, same "Run" just a different file (also pdf). what could be the reason for this?
Hi Leila, thank you for the video. Can you make a video or let me know "How to send a pivot table from excel in email with body message, table and my default signature" ?
Can you add a different password easily through a similar process to the individual pdf's? I would like to add a column in the Excel file populated with the password. The hope would be to change the pdf's to a password protected sheet before emailing.
Been struggling all week long! Such a great solution and wonderful tutorial, thank you!
Thanks Leila. Always interesting tips from you :)) Thumbs up!!
Thank you! 😃
Hi Leila, thanks for the video, it is very clear! I have followed all the steps, however the attached file is blank when it is sent and received (if it is a pdf), or it cannot be opened if it is an excel file... Do you know why? Thanks again!
me too! Let me know if you solved the blank pdf issue
@@lukecarter7035 Yes! (thanks to @ekarim2020). I hope I can be able to explain how:
Edit your Flow, go to Send an Email section, then to Attachments and make sure there are not quotes around the values for the ContentBytes. (The word ContentBytes should appear between quotes, but the word File Content shouldn’t. Is should look like this:
[
{
"Name": "name",
"ContentBytes": File content
}
]
Thank you Leila for this video! I do have a question for you, I'm having a hard time getting my dynamic File Name to match the Display Name of the file in the folder. When I try to run the flow, I get an output error of 'false'. Can you please help me?? I really appreciate it :)
Having the same issue too. Did you manage to resolve it?
Even I have same issue