Power Automate Desktop to send emails via Excel/Outlook

In this video, I demonstrate how to send emails from outlook with email addresses in an Excel workbook. This also serves as an introduction to Power Automate Desktop and reading data from Excel
#PowerAutomateDesktop
#Excel
#Desktop

[@zsowson]

Thanks a lot, it was a great help, now my co-workers are amazed what I could do for them :)

[@ExcelMoments]

Now the superstar of the office. That's really great to know

[@haihathanh5061]

Very amazing video!!! It's really simple for a beginner to understand like me. Thanks a lot for sharing!

[@ExcelMoments]

Thanks for the feedback. I appreciate it

[@krishanramgulam8693]

Great video! Just what I was looking for and clearly explained

[@ExcelMoments]

Thank you so much for the feedback

[@idhamaljaroo4708]

Awesome video!!! no nonsense, straight to the point with crystal clear explanation. It actually works! Yay :)

[@ExcelMoments]

Like you had some doubts about it working 😀😀 Thanks for the feedback, very much appreciated

[@renneco]

The ExcelData[] looping is incredibly powerful information that will save me tons of variable assignments! Great video! Thanks

[@ExcelMoments]

Yea, really powerful. Glad you found it helpful!

[@TimUnknownable]

YOU ARE AWESOME!!! watched many videos with similar training, but this was super clear and concise for what i needed!! youve earned a SUB, you saved me a lot of money instead of having my employees send redundant emails!!

[@ExcelMoments]

Probably the best feedback received. I am glad money was saved and that you found it useful

[@SoundMusical_Official]

This has literally helped me more than anything in my music academy business. Thank you so much for your help!!

[@ExcelMoments]

Pleasure to have been of help

[@jareg4033]

Power Automate is here! Great video, please make more on Power Automate 👍🙂

[@ExcelMoments]

Thanks for the feedback

[@rafaelrosa6400]

Thank you for the video! Extreme usuful tips! Saving a lot of time using that.

[@ExcelMoments]

That's great to know. You are welcome

[@IvanCortinas_ES]

Excellent explanation Victor. Would there be any advantage to having the Excel sheet configured as a Table? Thank you!!!

[@flydrew2781]

This helped me save a lot of time in my job

[@ExcelMoments]

I am glad you found this useful and helpful. Thanks for the feedback

[@user-ws9qh9we6j]

Thanks a lot for the video!

[@michaeldaniels6627]

Great video, just exactly what I was looking for. The video was super clear. Thanks

[@ExcelMoments]

Great. I appreciate the feedback

[@happymealways6093]

Thank u so much it helps a lot and keep doing powerautomate videos

[@ExcelMoments]

Thank you for the feedback. Very much appreciated

[@mayankkashyap5646]

Thank you so much

[@ExcelMoments]

You are welcome

[@mohebyoussef3284]

Thanks alot for your greate effort

[@reecejordan24]

Thank you so much. This will save me so much time!

[@ExcelMoments]

That's really good to know

[@user-fx7gl5rd5n]

Thanks for this great video!

[@ExcelMoments]

You are welcome

[@saiedesmaielifard5317]

This video is REALY helpful for someone who dont know how to use power automate. Victor describe everything from scratch. I have a question Victor. how could I send email with personalized attachment via P.A

[@ExcelMoments]

Thanks for your comments. I take it that you probably know the location of each recipient's attachment. My suggestion would be to maybe have the Path in a column , just like Name, duration and any other parameter. Then in the Flow, there is an attachment field as part of the mail set up and you can just point it to that column. It should be easy if the data is already in excel

[@limweihong6142]

This is so helpful! Thank you so much ❤️❤️❤️

[@ExcelMoments]

You are welcome I am glad you found it helpful

[@limweihong6142]

@@ExcelMoments Hi Sir, I'm new to all these, by following your method, I'm trying to specific the font type to "Times New Roman" for part of the email body and another part by "Arial. Is this possible?

[@ExcelMoments]

@@limweihong6142 Yes, in that case, you will be using the option of "body is Html" and take advantage of some html tags. For example Hello You are invited for an interview Regards, Line 2 would be arial and line 3 would be in "Times New Roman". Something like that

[@petertolerance9158]

very impressive

[@ExcelMoments]

Thank you very much

[@olufemiogunrinde1341]

One of the clearest training clips I have watched in a long time. How do I use loop condition?

[@ExcelMoments]

Thank you for the feedback., much appreciated. For every loop there has to be a condition that helps one exit the loop, else it runs infinitely., if i know that I want to loop through 10 files, i may just use a regular loop and say run 10 times, but lets think of a hypothetical situation where maybe i am looping through workbooks in a folder and i want to copy data out of any workbook that has a sheet named "Femi" and once i have copied data from 5 such workbooks, i want the looping to end. I could use a loop conditional and i would have a variable that counts how many of such workbooks i have encountered that have a sheet called femi, once that variable hits 5, the loop should stop. So it is like a Loop while or Loop until if you are familiar with loops, loop while var

[@olufemiogunrinde1341]

@@ExcelMoments Thanks a million for the prompt response. I have a worksheet that serves that has a column labelled "Available" and with responses Yes and No in the cells corresponding to responses earlier obtained from participants. I want to send email to invite only that responded Yes. How do I set a variable for this column so that I can use loop condition? Thank you.

[@ExcelMoments]

@@olufemiogunrinde1341 Alright. Thanks for putting context to it. So in that case, it is not like you want to exit the LOOP when it shows NO. So what you do is to put an IF within the Loop. So inbetween the Loop and End, you would have an IF-THEN, the IF will check if that column has a Yes and if it does executes the commands that follow, else it skips to the next row. So you need an IF within the LOOP not a LOOP conditional per say

[@olufemiogunrinde1341]

@@ExcelMoments Thank you very much!

[@ExcelMoments]

@@olufemiogunrinde1341 If you run into any challenges, please let me know

[@daffaburhan6675]

Great video! Is it automatically send everyday or we have to setting manually?

[@ExcelMoments]

If you have a premium license , you can schedule it via power automate cloud version to run at a certain time everyday or whatever frequencies you choose

[@hazniedahazalli8322]

Sir, i did add column folder path because i want to send Email with attachment, do you mind showing the tutorials?

[@elcarryboo9344]

Hi ! Excuse me but what's the difference between "For Each" and "Loop". It's a bit confusing for me. If you have some examples to illustrate it I'll be glad. I don't know in which cases you have to use Loop or ForEach.

[@dataisfun4964]

So many possibilities.

[@ExcelMoments]

Absolutely. It is endless

[@faisalmehmood6889]

Great experience to hear from you. such a important automation. I created the whole process when i run it error generated "Failed to sent email message" Status: Runtime Error Found I try to fix it but couldn't.

[@ExcelMoments]

but it launches outlook correctly, just doesn't send the message, right? See if you get some help here docs.microsoft.com/en-us/outlook/troubleshoot/security/a-program-is-trying-to-send-an-email-message-on-your-behalf

[@faisalmehmood6889]

@@ExcelMoments Yes it does launch outlook correctly also messages / email stuck in outbox. But it didn't sent

[@galaxygaming3814]

Loop index is out of range why thise problem are resolved

[@devyanianimalsjadhav8313]

Can you please show us how we can include Tables in emails using power automate desktop flow

[@ExcelMoments]

Hello. A table from an Excel Range? or just any table

[@margaretwidjaja9981]

in the most updated POwer Automate, we can no longer use [] and 'named_column'. how can i refer to certain column without using those method?

[@ExcelMoments]

That's an interesting update!, Can you use the column index in place of the name. i.e %ExcelData[1][2]% which would mean row 2 and column 3 from the data set

[@margaretwidjaja9981]

@@ExcelMoments%ExcelData[1][2]% didnt work too..

[@citraadi23]

how to insert Row table excel data at body email ?

[@ZafrullahMalik]

There is no option to add hyperlink or picture in the body of the email, How can I add a hyperlink that would allow people to schedule a meeting with me? If I have a signature already defaulted on outlook will it need to be copied into this body or will it be in the email when i send it?

[@ExcelMoments]

If you change the option of formatting the body as HTML, that would open up some more options for you to work with - pictures and hyperlinks

[@thepost1]

iam getting error as failed to launch outlook how to solve this problem kindly help me

[@ExcelMoments]

Is outlook already running before you call the flow, if that's the case, you can try closing outlook before launching the flow Or in your flow, you can add a Terminate Process action and terminate outlook before proceeding with the flow. Let me know how that goes

[@bgmafuz]

Sir if i want to attach individual Admit Card pdf file then what is the code??

[@ExcelMoments]

There is a field for Attachment in that dialog that popped up. Easiest thing would be to add a column to the data in excel for the file paths and then you simply reference that column in PowerAutomate, where it asks for attachment

[@agnimitraghosal3384]

I love your videos.. But I need some help regarding this same flow. How Can I contact ? Is there any mail id where I can drop a mail ? Thanks in advance ..

[@ExcelMoments]

[e-mail]

[@rurorack4280]

i have an error that "Column or property 'Email' not found." How do i fix this? Could you mind tell me please?

[@ExcelMoments]

On what line does this error come up? Did you add a property called Email?

[@rurorack4280]

@@ExcelMoments thank. I have check it my self and set up for read data from excel node in my script dont read first row as property. But i fix it in advance options.

[@ExcelMoments]

@@rurorack4280 So you have fixed it?

[@rurorack4280]

@@ExcelMoments yes. My default node didn't tick in "First line of range contains column names" so the property are column 1, column 2 etc but not First Name, Last Name, Email.... i just tick it on and everything are perfect.

[@nomanbhatti9045]

what if i want to add delay of 5 minutes between two emails?

[@ExcelMoments]

There is a wait object which you can include and specify the duration(in seconds)

[@nomanbhatti9045]

@@ExcelMoments liked and subscribed your channel for reply on delay in power automate, i will try if i don't succeed then you have add 2 minutes tut for this :)

[@ExcelMoments]

@@nomanbhatti9045 Hahahaha, sounds like a fair deal. But we need to distinguish "Not working" from "Not working for you" 😄😄

[@nomanbhatti9045]

@@ExcelMoments it worked and i saved too much time, thanks to you. when i am using respond to outlook message, how i can put html email body content, and most importantly how i can put the name variable to whom i am sending emails

[@ExcelMoments]

@@nomanbhatti9045 Are you referring to Power Automate Desktop? Just to be sure I have the right context