Power Automate Desktop to send emails via Excel/Outlook 

Thanks for the feedback. I appreciate it

Thank you so much for the feedback

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

That's great to know. You are welcome

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

Thanks for the feedback

Pleasure to have been of help

Yea, really powerful. Glad you found it helpful!

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

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

You are welcome

Thank you for the feedback. Very much appreciated

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

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

That's really good to know

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

@@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.

@@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

@@ExcelMoments Thank you very much!

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

Great. I appreciate the feedback

Thank you very much

You are welcome

You are welcome I am glad you found it helpful

@@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?

@@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

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

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

Vicmomentum@gmail.com

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

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

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

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

Is Outlook properly set up on your PC, and can you launch it manually?

@@ExcelMoments yes it is, actually I tried it this morning and it worked 🙂 as figured out how to include attachments 👍. Thanks for the tutorial

Absolutely. It is endless

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

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

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

@@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.

@@rurorack4280 So you have fixed it?

@@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.

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

@@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 :)

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

@@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

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