Send Emails from Excel with Power Automate

[@Budgetblueprint786]

Dude I just want to take a moment to take my hat off to you. I've watched 100 of hours of power automate and some how your videos turned out to be the most crucial to my beginner journey. You really have a way of simplying it to a point that even the least tech savvy are able to implement the above

[@HowToExcelBlog]

Thanks for the feedback. Glad it helped you.

[@MDTPBI]

Incredible video. Your calm voice paired with clarity and preciseness in language makes this an easy to understand video. Keep doing what you're doing, John.

[@Ashwin2025]

Awesome! I'm happy to be on Earth now with a feeling like everyone around me is trying to help me to Excel!!

[@corziques]

Glad I came across this video. Simple and effective. Great Tutor!

[@jordancohen2355]

Thanks for this video! I've been looking for a way to do this without writing VBA and here it is!

[@jurnalmarhaen3800]

Exactly what i need right now.. Simple and straight forward.

[@MustafaMMustafa]

The classic mail merge reimagined... Cool. I'll have to try it this way soon to decide which method wins. Thank you for the video.

[@HowToExcelBlog]

Go with the modern methods. It can do so much more!

[@danielmazariegos8685]

Great explanation!!! THanks for the help

[@jiajiaphotography]

How cool is this! I will test this right away. Thanks 👍

[@gopigopichand4379]

Thank for sharing.. awesome..

[@HowToExcelBlog]

Power automate is awesome!

[@priyankathaddaeus4082]

Thank you for sharing! So simple and succinct!

[@VikasSingh-em3ol]

Awesome and very helpful video sir.

[@HowToExcelBlog]

Thanks! Glad it helped.

[@mehdihammadi6145]

Very interesting I will definitely explore this solution deeper

[@HowToExcelBlog]

Yes! Power Automate is a must to try out!

[@paulblais9210]

Hi, great video straight to the point but I do have questions, 1- does this work when a new entry is created? 2 - will this work if I use a form in excel to create my data sheet in excel? Thank you, Paul

[@HowToExcelBlog]

Unfortunately no. There is no trigger for when a row added. But if you're using a form, there is a trigger for that.

[@shrutikadongre1046]

This is helpful, thankyou!

[@rahuldinesh2840]

Great video. Very useful . Thanks

[@conniewhitehouse.arteaga2910]

This was a great tutorial. One question, what if I wanted to not only have a dollar amount but include a list of outstanding invoices? Do you have a tutorial on that?

[@wayneedmondson1065]

Hi John.. thanks for sharing this. Lots of interesting things possible with Flow / Power Automate. Thumbs up!

[@HowToExcelBlog]

Hey Wayne! Yes, you can do a lot with Flow. I've been working with it quite a lot lately and it's my new favourite service.

[@show_me_your_kitties]

I have been on KZbin all day searching. Thank you so much this is going to help so much

[@michaelprasan]

Dude that was very helpful

[@DougHExcel]

Nice! A good alternative to Word Mail Merge>

[@HowToExcelBlog]

It's a billion times better than a mail merge. You can do so much more with power automate!

[@cyclingmc]

How To Excel do you have more advance videos using this process. More complex example.

[@HowToExcelBlog]

@@cyclingmc this will get you started kzbin.info/www/bejne/haG0anxsgL-fi6s

[@JuneQ1991]

This video is awesome, thanks for sharing!

[@thanitsorn]

Great Video. Thank you so much.

[@adrianocesar4975]

Excellent explanation! Very useful!

[@HowToExcelBlog]

👍

[@edisondiaz4748]

Thank you for the video. I have question! You demonstrate that by clicking run, the value will be sent to email. Is there any way that an email will be sent automatically if the excel was updated? It is like this. I have forms, in that forms, i want the score to be sent to my email. Can this be done?

[@marconimamauag5653]

Hi! This is a great video. It's simpler and straight forward. Just want to check on how to send 2 or more columns/rows to a single receipient? Thanks!

[@yanmora2139]

Hi, Marconi did you find how to send tables?

[@marconimamauag5653]

Not yet..

[@jpkamalanathan3859]

Sir in this video, Working with different attachment for individual email address?

[@SofiaGonzalez-bv1hh]

Hi! great video, could you make a tutorial on how to automatically paste a graph into de body of the mail? Also, is there a way to change a paragraph depending on the data of the day? Thanks!!1

[@muhmedsuhel4987]

Great ! Appreciated.

[@6206Films]

Hey mate, this is awesome and will be super helpful for us chasing payments. I did want to ask one thing. Is there a way to make the emails NOT automatically send, but to have excel speak with Outlook and basically generate the emails that then will pop up on our screen so we can make some edits. I ask because some of our chasing is for multiple invoices, or we will need to attach documents that might not always have consistent naming. Hope you can help! Your video was amazing and so so clear!

[@timothyroy6670]

Thank you for this video. Is there a way to trigger an event when a particular row has been changed. For example, let's say one row has a dropdown that either can have approved or rejected. Is it possible to send an email with the value (approved/rejected) to certain people when it is triggered? Thanks in advance!

[@asifborouge]

Thanks for sharing valuable videos........... I am trying to learn how to set up excel sheet to send email without opening it. The case is, I have several systems to be verified after a regular interval for their integrity. All systems are listed in an excel sheet and a condition formatting is applied to determine the due date for system integrity verification. Can we do it (I mean the email should be sent as a reminder to the concerned person on a due date without opening the excel sheet)? Thanks

[@silviamalheiroportalgestao3501]

Very well explained! Thank you! This was super helpful :)

[@HowToExcelBlog]

Glad to hear Silvia. Any ideas on how you'll start using this in your work?

[@InsightfulJourney123]

Amazing!👏Thank you, Sir! Subscribing

[@sceadwe]

Finally a tutorial video that enabled me to create the flow I want. However, when I closed the file and try launching my saved flow, Excel prompts I have no flow for the same file. Ended up doing the entire process, but Run button is disabled for the same file. Please help me out. Thanks!

[@joaquingallardo12]

Hello, have solve this?

[@ryanvh21]

check that all your Microsoft accounts are the same - the one you store the file in and the one you edit in or it won't link up.

[@Mewkucinglucu]

Thanks for the video. Do you know how many max email that power automate can send per day?

[@eshakaur6609]

can we send email reminder to multiple emails from one column in excel and when one email has updated the status as "Completed" power automate will stop sending the email reminder but continue to send to the rest of the email from that one column

[@francoispo1481]

amazing

[@simonkariuki1679]

This is very nice. thumbs up. How do you add some people to the cc?

[@AK-qo6vw]

I wanna send different files to each individual. How can we do that?

[@268803465e]

Very cool flow. Will it avoid bulk email/spam filters?

[@brillz55]

Awesome instruction - Is there a way to set up a flow to reply to a specific email that was previously sent. For example if I sent you an email on 4/21/2021 and wanted to follow up on 4/22/2021 by replying to that specific email. Can this be done in power automate?

[@connor3563]

I've wanted to figure this out as well. Did you find a way to do this?

[@show_me_your_kitties]

Create another table, set up the dates and emails.

[@richardng6729]

Awesome! I love it.. Can this be applied in WPS?

[@michaelkhup]

Thank you for the tutorial sir. If I want to send separate email to multiple people with different values. How would I do it? Is there away I could send all individual emails at once?

[@SpartanGyrl08]

I wonder if you could separate email addresses with a comma like you would in an email....

[@HowToExcelBlog]

A comma list will send a single email to all in the list. If you want to send a separate email, split the list in power automate, then loop through the resulting array.

[@SimplyMoi91]

Hi, would it be possible to have the emails accumulate in your outbox in order to attach items?

[@MrPhariset]

Can you show an example, where you have maybe 3 different companies each with their own email address but multiple invoices due, where it would NOT send a seperate email for each single invoice due, but send a single email to each of the 3 companies, with the data from each row that is relevent to that specific company?

[@kalpeshpatil5959]

Thanks for this video.it is very useful. When I am trying to get flow app from store then it shows error. Also 1 question...do we really need onedrive sharepoint for power automate..? Bcoz current organization not giving access of onedrive or sharepoint. Is there any alternate way?

[@richelsantiago]

can you show us how to add pdf attachments in Excel? need to send individual files to individual email adressess. thanks!

[@clickbisi7016]

Hey Rich, Did you ever find the answer for this? Or video that shows you..

[@richelsantiago]

@@clickbisi7016 sadly, not yet. but there is a way thru sharepoint and powerautomate. It is a bit complicated though

[@clickbisi7016]

@@richelsantiago ahh yes I was looking into that but my work 365 account is not linked to REST API so won’t work with Outlook. I have however found a tool created by Doug Robbins that works as an addin to the usual MS Word+Excel desktop mail merge, google ‘Mail Merge Tool Doug Robbins’ if you’d want to check it out

[@MichaelDewTechTips]

This video shows how: kzbin.info/www/bejne/faDTd51motV6e8k

[@FrankdTankytchannel]

OMG!! This is so helpful! But how should I run this again if ever I've added more data e.g. names, email and amount?

[@sidiyer841]

Would it be possible to do this from a shared mailbox?

[@agoogleuser6937]

Could you chose a different “from” email address for esch recipient?

[@arvindpjinturkar6112]

HI, Thanks for detail explanation. can we put date specific reminders.

[@abhishek3667]

Yes this is instant flow , you can use schedule flow.

[@BrendaJOtter]

This is definitely a new twist from using other merge software. Is there a way to have automated emails sent out such as a birthday email to staff on their specific birthdays or does this need to be done on a daily basis?

[@HowToExcelBlog]

Yes, you could do that with power automate. Set up a scheduled flow that runs every day, filters an Excel table that contains all employees by those with a birthday today, then email.

[@BrendaJOtter]

@@HowToExcelBlog Thank you for your reply. I will definitely look into this.

[@bchakradhar]

I have a sheet with duplicate recipients with multiple companies under them. How can I consolidate the multiple companies and send one email to each recipient in place of multiple emails.

[@MY-bz5jp]

i am having this same question also, how to send one email (in which there are multiple companies) to that recipient?

[@Letty-25]

Same question. Would be nice if the rows for the same recipient can be consolidated into just one email. Has anyone of you figured out a way to do this?

[@priyeshchheda6684]

How can we add an interval of time in between sending mass emails?

[@tier1athlete829]

Can this be done without having peoples email in excel. So just having them type in a persons email or be able to just pull the email from their personal email?

[@peewee6132]

How would I include my signature on these emails?

[@KevinJohnson-he4pe]

is there a way to make it send these emails automatically when a certain trigger is hit? for example if you had a due date column can u make it do exactly what it did but only when its the due date?

[@griffey11]

I have the exact same question. were you able to figure out how to do it Kevin?

[@camrob7537]

Me too 😂

[@HowToExcelBlog]

You could set a scheduled trigger every day, list all rows in the table with Odata filter when date = today, then send emails.

[@carmela6740]

Great Video! Instead of running the flow for selected cells, is it possible to run when a condition is met? (For example before somebody is running out of stock). Stock is updated once a week, a nice form for ordering is linked to the online excel if somebody already run out but a warning message for ordering before stock ends would be greater! At the moment we handle this step manually. Regards! Carmela

[@HowToExcelBlog]

I used the selected row trigger, but you might want to use the schedule trigger to run every day (or every hour). Then list rows in your Excel table with a filter on those that need restocking.

[@carmela6740]

@@HowToExcelBlog thank you for your answer! I will definetly try that!

[@carmela6740]

@@HowToExcelBlog it worked! 😁

[@HowToExcelBlog]

Good to hear! Have fun with power automate, it can do a lot 😀

[@gargimitra2010]

I want to schedule the emails based on a date column (Duedate) at the table. If today=Duedate, then only mail should go with details on that specific row. Please suggest.

[@MatanDiermeier-Lazar]

Do you need to have a Microsoft Business account to use automate? My personal account does not let me use Add-In's at all

[@daniellovestodance]

3.07 add a table. that part wasn't quite clear. how was the table already populated?

[@khekiw3094]

Hi, my date value transfers to emails as number. How yo change? Also can i send email row by row. Sending individual emails at multiple times per day as an item is updated

[@gavp5248]

Hi, great tutorial! How do you email the whole table in the email?

[@SttConsultores]

Same question 🙂

[@dennismunchua5336]

Good day, what is the maximum number of emails allowed for this flow? Thank you

[@thanhnhan3027]

thanks for your video. but i want to send mail with attachment. can you help me

[@poojathangaraj7838]

Thanks for vedio but after i done all the step I don't run the history some things went wrong

[@vijayakumar1269]

Thanks for the wonderful video. Is it possible to send the meeting request in outlook using excel file and including Microsoft team in it ?I am trying to get the data from excel file and send outlook meeting requests including Microsoft teams in it. I tried with the UIPATH, I can send the outlook meeting request but we cant include the Microsoft team in it and I don't want to record the process in the UIPATH. Could you please let me know if you can do something in Power Automate. It will be really helpful. Thanks

[@CardanoKing]

Is there a way to automate emails without having to add in "Flow"? My company does not allow us to add add-ins :(

[@sheilajohn8405]

You should be able to do this with VBA

[@garyzeune8127]

GREAT tutorial. BUT does anyone know how to tell if the reciever viewed, opened, or clicked a link in your email?

[@HowToExcelBlog]

Create your links with a service like bit.ly

[@InitiatorG]

How about adding an attachment?

[@HowToExcelBlog]

You can definitely add an attachment in the flow.

[@ISIKSAHIN]

Amazing ... Can we send an email without sign in to the system or when your computer is off for example ı have an excel table and there are due dates so i need to send reminder 30 days before the due date without login to my computer is it possible?

[@wesleyeccles5841]

What if the email in your excel file is created using vlookup for example. The flow pulls in the function and not the value and therefore it doesn't work. is there a way of getting flow to pull in the string and not the function? WITHOUT converting the formulas manually in the excel file by copying and pasting as values. The list continuously increases due to forms data imputing into the excel file. Thanks.

[@HowToExcelBlog]

Does it? I was not aware of that. If you come across a solution, let me know.

[@HowToExcelBlog]

You could do the vlookup in Flow (get rows from table then filter on a given value).

[@janlouisemakiling3474]

How can I keep the email format from the flow 😅 The email format (font text and color) keeps on changing even I saved it multiple times

[@norfarahinrazali63]

Hi, is it possible to add an attachment on the email as well?

[@shrishabhat2978]

i am not getting option to run here, what can I do?

[@InspiringthePlanet]

Is it possible to send an email every time a new row is added to excel file ?

[@jackieladeras7251]

Hello, such a great video and this is exactly what we need. I tried it and followed exactly what was done on the video. For some reason i can't run the flow. 1st attempt, the Run option is disabled. 2nd attempt, the flow i created is after i saved it, the flow is gone in excel. when i logged into my power automate, the flow that i created is there. but since it's not showing in excel, i can't run it either. hope you can help..thanks in advance!

[@KiranVoletiOmGuru]

i am having the same issue.. the Run option is disabled. Any idea if this has to be purchased as outside Office 365?

[@KiranVoletiOmGuru]

hey, i found out why.. it all should be in text format to run the flow.. so incase you have any column/field in number format, it wont enable.. try converting it text and see.. hope this helps!

[@alymoehle4948]

My edu has locked out users frm adding any add-ins at the user level. Is there another method or way of installing this? I am going to ask my IT office to whitelist it, as it is MS made, but it might be an all other nothing type situation (students, staff, faculty). They don't tend to allow them if that is the case, like with some google add-ins as well.

[@HowToExcelBlog]

You can still build flows by going to flow.microsoft.com and logging in with your office 365 credentials. Can build lots of other types of flows there.

[@alymoehle4948]

How To Excel thank you will try!

[@mercuriallimit]

my situation is, I would like to make a registration link. After clicking the link , what I would like to happen is 1. have a place to type in email address, name 2. add the name to an excel file for record and add the email to MS Team group 3. send email confirming the registration and 4. notify the registered member when the meeting is about to happen. Could this be done? I don't see the big picture of how each modules ties in together. Thank you

[@HowToExcelBlog]

Yes, this can be done. Use an MS Form then use power automate to create a user in azure AD when a new response to the form is submitted then add the user to a Team.

[@Hbedin92]

Hello, what if I have 3 different email addresses!? How should I do the flow?

[@roxanaignat323]

Hi, an attachment can be added? thank you

[@benzjoseph8794]

It won’t let me run the flow. Ps: I’m using my school’s email. Is that a problem?

[@ravijha7316]

hi john on e query i want to choose my file so how do this bez I have not seen my file except other fils.

[@hansusuno]

Hi...how can we add an attachment in this for each row.

[@arjunt6334]

How to send email to selective list within the same column?

[@fegyenc]

Do you have a solution if I would like to send multiple lines in 1 email? Thank you in advance

[@HowToExcelBlog]

Use list rows in power automate and perform a join on data.

[@roltol7539]

yes i just took my time to learn vbs macros, and that one is 100% working :)

[@ashishlotia6724]

Is there a way of scheduling the report?

[@HowToExcelBlog]

Sure, use a scheduled trigger in power automate.

[@gargimitra2010]

Have you got the solution Sir ?

[@gargimitra2010]

While scheduling in Power Automate, how to define condition there? Suppose email should go on Due dates only.🤔

[@geepee3571]

Is there a way to mail to one person but then include the others in CC?

[@AT_PokemonTCG89]

Great video, question. I have an excel sheet that I need to send out on a cadence. I am unable to pull the email contacts from the report onto my report but have the first and last name of the people I need to email on my report. Can MS Flow use the first and last name contacts within my company to email the report to action? Thank you for the video.

[@HowToExcelBlog]

I think you can use the office 365 connector to search for the user and get their email.

[@gordonproud6284]

@@HowToExcelBlog @AT how are you setting up your spreadsheet for a cadence delivery? How did you set up your list and PA to do a cadence? I am looking into using this as a temporary method for sales prospecting until we get SalesLoft live.

[@krishnabairi1581]

I have similar use case with small change, I need send multiple approval emails based on excel but I a am facing an issue that the flow is running in loop, unless the first email is not approved, it is not getting triggered the second approval for the next row in excel. Can you please let me know how can I solve this?

[@blueight]

Can i add dates when the email should be send?

[@MalluFunGo]

What about multiple date for single email let’s a bunch of invoice and it’s amount to different emails how can make it possible

[@nicku8]

HI this might sound tough to achieve but can you tell me how to automate unique email body with multiple paragraph from excel where the end receiver should be able to receive proper email format i need to this be implemented in power automate flow

[@HowToExcelBlog]

Might be easier to create the email body in Excel with formulas or otherwise

[@nickukris3628]

@@HowToExcelBlog I tried my best using formula %0A for body and divide the body into differnt paragraphs but still its not working, please can you help me in this as ill be saving 5 hrs per day

[@dbss8999]

How can i get information to other excel (im not the propietary) but i want to join this information and search automatically information on that :(. In drive, it has "importrange" to get information to another excel but in microsoft 365 (onedrive) i dont know how to connect this when other person have the excel in onedrive. How i can do that with power automate?

[@HowToExcelBlog]

You can't search for an Excel file and connect to it from power automate. You have to pick the Excel file before the flow runs.

[@myathsu9390]

who can I request for admin approval because I cannot sign in Excel flow like this

[@big1975E]

Is there a way to set the flow to automatically run when manually entered data in the table is changed?

[@HowToExcelBlog]

There is no on change trigger, but you might be able to hack one together. I'll have to think about it.

[@big1975E]

How To Excel Awesome! Thank you. Is there a way to schedule tasks to run such as opening an Excel workbook once a day or once a week?

[@HowToExcelBlog]

You can definitely schedule a flow. Why do you need to open the file? Since it's in the cloud, you can run tasks without opening a file.

[@big1975E]

I have a workbook with macros that perform specific tasks and interact with other workbooks on a shared network drive. I want to perform those tasks once per week. I can trigger the macros to run when the workbook opens and then close the workbook when they are finished. If a flow can be created to just open the workbook once per week then the entire process becomes automated.

[@HowToExcelBlog]

You can use a RPA flow to open a workbook, but this is a premium feature in Flow and its still in preview.

[@shenggay18]

what if you want to consolidate the rows before sending to the recipient? Let;s say the emails are A@gmail and B@gmail, and some rows shoulld go to A, some to B?

[@leonardothereziano9541]

I have the same question,, did u find some way?

[@intanshaharudin9657]

my run button is grey and i am unable to run the flow

[@aparnapathak4651]

If I want to send notification to email ids in excel table column 15 days before the current date...would it be possible with flow?

[@HowToExcelBlog]

Yep, you could do that.

[@HowToExcelBlog]

Sorry, a bit more involved than a comment can explain.

[@alvatrofox]

Hello, in my table I have a date column, when I include it in the body of the email, it is shown as a number and not as a date. How can I make it show as date? So 08/18/2020, not "43869". Thank you