Kevin, great video! Please elaborate on how to attach customized attachments - I followed every step of you video but this is one step that I need help on. Thank you!
....As soon as you said you worked for Microsoft full time, I knew this was going to work! Clear and concise explanations and no 'Computer speak' jargon. Thank you.
Kevin, this is incredibly helpful, thank you! One thing I learned the hard way: there is a row limit of 256 unless you do this. In the List rows in a table step, click the 3 dots to get to settings. Turn pagination on, and then up the limit to what you need.
@@1precioussa How did you manage to show your work/business email instead of Gmail or Outlook email as sender? When I do it it shows sent from my personal email. SOS 🙂
UNBELIEVABLEE, I cannot put too much data here but this is the solution to a lot of frustration about writting tedious emails with sooooooo manyyyyyyy variable data on itttt. THANK YOU, you are a genious! You are the GOAT :)
Mail merge has saved me so much time and frustration with me no longer having to spend hours customizing the same email to thousands of people at my job. So this is super important that you are sharing this helpful tutorial. Thanks Kevin! :)
Hi @TylerStanczak How did you manage to show your work/business email instead of Gmail or Outlook email as sender? When I do it it shows sent from my personal email. SOS 🙂
Great advice at the end about doing a test run first. I usually test to myself once, then to a small number of real contacts and check the sent items before I go for the full run
You are a rockstar Kevin, I have been using Power Automate for 3months but i did think it can be use for mail merge, disciminating windows user account is 1 hell of a ride. thanks a lot you save me big time. More helpful tutorial please specially power automate. Cheers mate, be safe
My dearest Kevin, with this tutorial video, you made me productive thousands time better. You owe me, Sir. Salute to you! My love and blessings 🙏 for you!
Well, hearing that you worked on the Office home page made me smile big-time. Many thanks! It has improved a lot over the years and the new look is a big step up!
You are only one TH-camr (except my favorite bands) to whom I subscribed and turned on all notifications. People.... this man is LEGEND he has the best how to channel and his videos can make your life 197450981 times cheaper and easier. Thank you Kevin ^_^
You had mentioned at 17:10 you can send personalized attachments to each individual... Could we get a tutorial showing how to do this? That would be awesome! Great tutorial either way.
Hello @@Evan-Lemoine ! Could you share with us how did you manage to send a personalised attachment to each individual? Was it a PDF ? many thanks in advance :)
Nice tutorial. I added a column for conditional checks so I can have a running list of various contacts for different situations. I deliver a lot of reports and users are wanting to veer away from E-mail notifications so I now send them an MS Teams chat message when their reports are ready to view. It helps me maintain a distribution list that is selectable based on the report name. Good stuff... keep'em coming.
Thank you Kevin , its been a life saver for me ! using mailmerge with mac had been really difficult , power automate has been an amazing tool for mail merge.
Thank you, Kevin! I had trouble with mailmerge in Office 365. Word takes my oldest Outlook mailaccount as default in the mailmerge, not giving an opportunity to change it. I have more emailnames in my Outlook account To make it worse, I sometimes have to send mails from my website (separate account and not connected to Office 365) and couldn’t use mailmerge art all. This solution will save me tons of time 👍
I use mail merge for my job quite frequently, but this is a much better method. Thanks so much for sharing!!! Also, anyone else hoping that the Kevin Cookie Company actually becomes a thing??
This was very straight forward and easily digested. One advanced question I would have about Power Automate is whether a table can be added / populated using this method. I'm going to play with it a bit and see if that's possible. Thanks for this content.
Hi @rlcornish5400 How did you manage to show your work/business email instead of Gmail or Outlook email as sender? When I do it it shows sent from my personal email. SOS 🙂
This my first time hearing about mail merge and your video. I find this video very helpful, clear and resourceful. This is like to the next level. Thank you so much!
Kevin, i would love to see how you set attachments unique to each email address in the table. I am thinking the filename would have to be in a fiel in the table. Am I right?
This is exactly what I wanted to ask. I want to mail merge a bunch of course certificates and email to individuals. Can pdfs be incorporated for mail merge through power automate?
Thanks for this video Kevin - it has really helped me to be more efficient! Could you do a video on how to add custom attachments to the email? You mention it's possible, and i have tried, but I can't quite get it working.
Of course this is helpful Kevin, Thanks a lot. I am working on a small project at work and I will use this. Please do more videos on Power Auto. I am looking for customized emails approvals and struggling to track back whether or not approved.
This is too good but as you mentioned that we can do the customize attachments for different email, can you guide how to do this in the case when different attachments are in different folders.
That's great to know this. Its well constructed way of presentation. Much appreciated. Thanks a ton. For me it a timely video where i have to send about 80 custom emails to the team members.
So great tutorial! Thank you! It would be great if you could show how to create a mail merge when the Excel list consists of 1-5 rows. Say that the customer had one order/invoice, and the next customer had 3 orders/invoices. Once again, thanks!!!
Easy. I was do that. Just make 5 table insert that 5. Then the last 2 row may empty, other row filled I forget the different between row and coloum. At least you get the point
Hi Kevin, Just a quick note to say thank you. Your instructions were clear and helped me to efficiently distribute user names and passwords to a group of my students.
Hi Kevin, thanks a lot for taking the time to create all these tutorials. They are very useful. In this video, you say that it's possible to attach customized files. Could you please show us how to do it? Thanks again for your help.
Thank you Kevin, really going to be useful. So far I'm using libreoffice mail merge to send as pdf , say certificates. This looks more promising. I have few questions: 1. How many mails we can send using office365 school mail id? 2. How can I send certificate as attachment with dynamic fields inside, say for example how can I send certificate or selection letter as pdf attachment. I have organized a faculty development program with 9000 teachers participants and I need to send certificates as pdf attachment to individual. Please reply. Waiting for your reply.
thanks for this video Kevin! you are a life saver! would be great if you can also post a video on how to attach unique attachments. i think a lot has already requested.
Kevin this is awesome just what I was looking for, now just have one more request how can I send invoices for each customer so that each customer gets only their invoices?
Very helpful video, thanks! I noticed that after you finished running the job, all of the three emails had an incorrect date format in the subject line. Would you want to explain why that would happen and how to correct it?
Dear Kevin: I just started to learn about Power Automate. This video is really helpful. However, I need to send emails to different individuals with different attachments. Can you help to advise how to do it? Appreciate your kind advice. Thank you very much.
Hi Kevin. Thank you for the patient and clear step by step instructions on getting this to work. I tweaked a few things to get what I needed like multiple email to by adding ";". But.. How do I send the emails with my email signature?
This video is so helpful -- it is clear and concise - like all your videos! Question - I would like to do this, but using a WORD letter merge template instead of using email for the merge. AND the resultant merged letters(files) outputs to a PDF. The goal is to have PDF file (or files) of all the merged letters. Can you guide me on this? Even just provide the workflow Actions/ steps in power automate would be helpful. Thank you!
Kevin - very interesting and useful for creation of the mail merge. Perhaps you could add on a step for execution. I work with a number of "branch office" scenarios in which the staff have minimal IT background and no interest in learning, but have a task to perform. Setting up a "button" on the desktop or on a website that they can press to execute the Power Automate function would be useful. Thanks for your consideration.
A total Novice here but can you automate the conversion of the fields like date and currency to Text format with Power Automate prior to sending? A great video
Hi Kevin, your videos have been really helpful. Can you please also extend this mail merge video if we add some conditions in power automate to send out the emails.
Amazing tutorial, thank you for providing step by step instructions! Question, is it possible to create a hyperlink in the body of the email? I need to navigate the customer to their login client portal. Thank you again!
Millions thanks,just want to know more about how to set the conditional rules in mail merge and send out the mass email through outlook and power automatic
Hello Kevin, thanks for your video! It is amazing what is possible with Power Automate! I always used VbA (if mail merge was not possible with Word) and my colleague has to create the macros (and she has always done this great, because she is very nice and great in VbA). But now I can do this by myself and I think this will release her to more important projects!
Hello Kevin, Thank you so much for sharing. This was so great and sending email to those people on the list it looks like BCC because everyone get his/her email content without seeing others email. Great. I was wondering if using this someone will ever need to use BCC as we use it just to hide other receivers' emails?
It's amazing, giving me a lot of time to do other things. I have a question. How do I attach a PDF file with a different name to each email? The files must be in OneDrive alone or Local Computer.
Kevin, Awesome videos! Thanks for this tutorial! Sending emails has become a matter of minutes. Do you know if there's a way to send a range of emails i.e.: rows 20 to 35 and not the whole list?
I learned absolutely nothing because I was pre-occupied with the price of a box of cookies. Are they gold-plated cookies? Is it that edible spray on gold? Are you the actual cookie monster? Are these deluxe thin mint éxquisite, fudge ripple covered, edible gold tinted delectable cookies? because they're $50 a box. I'm kidding. Its a great tutorial. 4 years later, I'm still learning. Thanks for all that you do.
Dear Kevin, Hope you are well. At first a ton of thanks to you for such productive tutorials. I love your content and feel so glad after learning something new. In this video, I found that the date is not coming in the right format and not showing properly as a date. You can check this out at "15:41". Please let us know how to bring that in the correct format. Thanks Again.
@@KevinStratvert just to add, I had to add the dynamic content for the related fields again otherwise it still sent the former format and not the new text format. Thanks very much for your great work.
@@KevinStratvert Hi Kevin, this seems like a workaround, rather than a solution. My spreadsheet has hundreds of rows with dates that are used in formulas elsewhere in the sheet. I cannot format as text then manually write the date as text over each one. When formatted as text, the dates appear as, e.g. 45138. There seems to be a way to convert date formats within Power Automate using Expressions (similar to toggling field codes in a Mail Merge), but so far I have not figured out how to do this. Could you perhaps explain how this could be done? For bonus point: not only using Expressions to format the dates to convert 10/22/2020 to October 22, 2020 but also converting 7500 to $7,500 ? thanks!
Kevin you are just great. I have nothing to say about you. You are just a genius in computer. But I have a question for you and the question is : How can I install and use loom - screen recorder on windows. As my school has told to make screen recording on loom - screen recorder in windows 10. Please also show how to install loom (complete tutorial) in windows 10. Please make withing 8 September. BTW You are great And I know you will be able to do this.
Kevin, this is an awesome tutorial! I was looking dod a solution like this and this came along. How can I use this if I want to send birthday wishes to various customers on their birthdays?
Great tutorial, Kevin- how would this work if you had more than one line for a customer, say they bought two different types of cookies, so two lines in the table for each customer? Would they get 2 emails each?
Thank you for this explanation, is it very easy to follow and helpful. I was sent the link to this video from Doug Robbins after asking if a previous video, that showed how to attach bespoke, individual files in mail merge, would work on a Mac. After Doug confirmed it wouldn't, he recommended this video. It does seem like you mention this function is possible, however if you could confirm that would be appreciated. Thanks.
This is an excellent tutorial.Thank you so much for sharing! Would you please advise if we could create rich text in the email body (i want to send in a proper email communication template)?
What if we want the attachment to be unique to a specific person/ company. Does power automate have the capability to search for the unique attachment within a folder and select the relevant attachment for that person/company? Also great video!
Dear Kevin, many thanks for this useful tutorial video. I was wondering if you could have another video about converting Form response (with attachment as supporting documents) to PDF (custom format) and then email approver for approval (or rejection if applicable) and finally send notification to a form responder about the request status. Thanks in advance. Regards, Sothearith
thank you for sharing, it is a really great tool to work with. I have a question about this mail merge, Is it possible to mail merge the inbox? I mean when I receive messages is it possible to power automate all the receiving messages in excel? thank you so much
![Power Automate Beginner to Pro Tutorial [Full Course]](http://i.ytimg.com/vi/1p5kI7SYz4Q/mqdefault.jpg)
Kevin, great video! Please elaborate on how to attach customized attachments - I followed every step of you video but this is one step that I need help on. Thank you!
Thank you Kevin, you really are helping people, not offering products, you are guiding on how to solve problems. Thumbs up for you and your content.👏
....As soon as you said you worked for Microsoft full time, I knew this was going to work! Clear and concise explanations and no 'Computer speak' jargon. Thank you.
Kevin, this is incredibly helpful, thank you! One thing I learned the hard way: there is a row limit of 256 unless you do this. In the List rows in a table step, click the 3 dots to get to settings. Turn pagination on, and then up the limit to what you need.
Hi Kevin, can you show how to add customized attachments for each individual? That would be extremely helpful! 😃
@@1precioussa How did you manage to show your work/business email instead of Gmail or Outlook email as sender?
When I do it it shows sent from my personal email. SOS 🙂
UNBELIEVABLEE, I cannot put too much data here but this is the solution to a lot of frustration about writting tedious emails with sooooooo manyyyyyyy variable data on itttt. THANK YOU, you are a genious! You are the GOAT :)
Mail merge has saved me so much time and frustration with me no longer having to spend hours customizing the same email to thousands of people at my job. So this is super important that you are sharing this helpful tutorial. Thanks Kevin! :)
Hi @TylerStanczak
How did you manage to show your work/business email instead of Gmail or Outlook email as sender?
When I do it it shows sent from my personal email. SOS 🙂
Great advice at the end about doing a test run first. I usually test to myself once, then to a small number of real contacts and check the sent items before I go for the full run
You are a rockstar Kevin, I have been using Power Automate for 3months but i did think it can be use for mail merge, disciminating windows user account is 1 hell of a ride. thanks a lot you save me big time. More helpful tutorial please specially power automate. Cheers mate, be safe
My dearest Kevin, with this tutorial video, you made me productive thousands time better. You owe me, Sir. Salute to you! My love and blessings 🙏 for you!
Kevin this is awesome! Now we just need to know how to send unique attachments to each email address. That would be the ultimate-ultimate mail merge 🚀
Well, hearing that you worked on the Office home page made me smile big-time. Many thanks! It has improved a lot over the years and the new look is a big step up!
You are only one TH-camr (except my favorite bands) to whom I subscribed and turned on all notifications. People.... this man is LEGEND he has the best how to channel and his videos can make your life 197450981 times cheaper and easier. Thank you Kevin ^_^
You had mentioned at 17:10 you can send personalized attachments to each individual... Could we get a tutorial showing how to do this? That would be awesome! Great tutorial either way.
Were you able to figure this out? I would like to know how to do it.
@hernan ariza yes I did
@@Evan-Lemoine Would you be able to share your instructions on sending custom attachments using Kevin's method?
Hello @@Evan-Lemoine ! Could you share with us how did you manage to send a personalised attachment to each individual? Was it a PDF ? many thanks in advance
:)
Nice tutorial. I added a column for conditional checks so I can have a running list of various contacts for different situations. I deliver a lot of reports and users are wanting to veer away from E-mail notifications so I now send them an MS Teams chat message when their reports are ready to view. It helps me maintain a distribution list that is selectable based on the report name.
Good stuff... keep'em coming.
Hi Kevin, this is very interesting. Thank you so much. Can you please show how to send a different attachment to each person in the list?
Thank you Kevin , its been a life saver for me !
using mailmerge with mac had been really difficult , power automate has been an amazing tool for mail merge.
Your videos are by far my favorite for Microsoft productivity. Practical examples that are concise and useful.
Thank you, Kevin! I had trouble with mailmerge in Office 365. Word takes my oldest Outlook mailaccount as default in the mailmerge, not giving an opportunity to change it. I have more emailnames in my Outlook account To make it worse, I sometimes have to send mails from my website (separate account and not connected to Office 365) and couldn’t use mailmerge art all. This solution will save me tons of time 👍
Hi! This was very helpful! can you also show us how to send individual or personalised attachments? Thanks!
I use mail merge for my job quite frequently, but this is a much better method. Thanks so much for sharing!!!
Also, anyone else hoping that the Kevin Cookie Company actually becomes a thing??
Great video again Kevin, many thanks! As some other people asked as well I’d love to see how to do customized attachments
What you did in twenty minutes took me about three hours....🤦
but at least I can now do the attachment 😆. Thank you sir.
This was very straight forward and easily digested. One advanced question I would have about Power Automate is whether a table can be added / populated using this method. I'm going to play with it a bit and see if that's possible. Thanks for this content.
We're you able to add a table?
Hi @rlcornish5400
How did you manage to show your work/business email instead of Gmail or Outlook email as sender?
When I do it it shows sent from my personal email. SOS 🙂
This my first time hearing about mail merge and your video. I find this video very helpful, clear and resourceful. This is like to the next level. Thank you so much!
Kevin, This contents really help me to complete my task in just 10minutes (it was an hour to complete). Thank you so much.
Kevin, i would love to see how you set attachments unique to each email address in the table. I am thinking the filename would have to be in a fiel in the table. Am I right?
I would also! Do we need to use URL in the table?
did you find out how to do this?
This is exactly what I wanted to ask. I want to mail merge a bunch of course certificates and email to individuals. Can pdfs be incorporated for mail merge through power automate?
Thanks for this video Kevin - it has really helped me to be more efficient! Could you do a video on how to add custom attachments to the email? You mention it's possible, and i have tried, but I can't quite get it working.
Great service for the fellow human professionals.
Thank you so much dear @Kevin Stratvert for your selfless support and training for the needy people!
Of course this is helpful Kevin, Thanks a lot. I am working on a small project at work and I will use this. Please do more videos on Power Auto. I am looking for customized emails approvals and struggling to track back whether or not approved.
This is too good but as you mentioned that we can do the customize attachments for different email, can you guide how to do this in the case when different attachments are in different folders.
Kevin, your videos are so awesome. This mail merge will help us every month. Thanks!
That's great to know this. Its well constructed way of presentation. Much appreciated. Thanks a ton. For me it a timely video where i have to send about 80 custom emails to the team members.
So great tutorial! Thank you! It would be great if you could show how to create a mail merge when the Excel list consists of 1-5 rows. Say that the customer had one order/invoice, and the next customer had 3 orders/invoices.
Once again, thanks!!!
Easy. I was do that. Just make 5 table insert that 5. Then the last 2 row may empty, other row filled
I forget the different between row and coloum.
At least you get the point
This is indeed the ultimate way to send mail merge!
Hi Kevin,
Just a quick note to say thank you. Your instructions were clear and helped me to efficiently distribute user names and passwords to a group of my students.
This tutorial really helps me with my mail merge. Thanks Kevin.
OMG!, it totally worked. Thank you so much. I'm looking pretty good to my boss lol
Hi Kevin, thanks a lot for taking the time to create all these tutorials. They are very useful. In this video, you say that it's possible to attach customized files. Could you please show us how to do it? Thanks again for your help.
Did you find out how to do this?
Thank you Kevin, really going to be useful. So far I'm using libreoffice mail merge to send as pdf , say certificates. This looks more promising.
I have few questions:
1. How many mails we can send using office365 school mail id?
2. How can I send certificate as attachment with dynamic fields inside, say for example how can I send certificate or selection letter as pdf attachment.
I have organized a faculty development program with 9000 teachers participants and I need to send certificates as pdf attachment to individual.
Please reply. Waiting for your reply.
thanks for this video Kevin! you are a life saver! would be great if you can also post a video on how to attach unique attachments. i think a lot has already requested.
Kevin this is awesome just what I was looking for, now just have one more request how can I send invoices for each customer so that each customer gets only their invoices?
Very helpful video, thanks! I noticed that after you finished running the job, all of the three emails had an incorrect date format in the subject line. Would you want to explain why that would happen and how to correct it?
Because Excel works in the American version of dates. I would suspect you would need to convert the date format first.
Dear Kevin: I just started to learn about Power Automate. This video is really helpful. However, I need to send emails to different individuals with different attachments. Can you help to advise how to do it? Appreciate your kind advice. Thank you very much.
You have no idea how much you are helping us!!!
Thanks
Wow! this is great information. I just started my own project with this tutorial. Thank you!
Very very helpful. Thank you Kevin. You make everything so easy to understand.
Great video Kevin. Power automate is very powerful indeed.
Hi Kevin.
Thank you for the patient and clear step by step instructions on getting this to work.
I tweaked a few things to get what I needed like multiple email to by adding ";".
But.. How do I send the emails with my email signature?
Did you find out how to do this?
Just write copy paste your signature there.
Yes with this step your signature will not attached
Fantastic video Kevin, I will now look for more power automate and Flow videos. Learning so much from you. Cheers.
This video is so helpful -- it is clear and concise - like all your videos! Question - I would like to do this, but using a WORD letter merge template instead of using email for the merge. AND the resultant merged letters(files) outputs to a PDF. The goal is to have PDF file (or files) of all the merged letters.
Can you guide me on this? Even just provide the workflow Actions/ steps in power automate would be helpful. Thank you!
Dear Kevin,,, your tutorials makes my life easy :) ,,, THANK YOU
Kevin - very interesting and useful for creation of the mail merge. Perhaps you could add on a step for execution. I work with a number of "branch office" scenarios in which the staff have minimal IT background and no interest in learning, but have a task to perform. Setting up a "button" on the desktop or on a website that they can press to execute the Power Automate function would be useful. Thanks for your consideration.
A total Novice here but can you automate the conversion of the fields like date and currency to Text format with Power Automate prior to sending? A great video
Useful tool. Excellent teaching tutorial.
Great video Kevin. Can you also explain how I can add a different attachment for each person on the mail merge list? Thank you
Thank you for posting!!! This is exactly what I was looking for!!!
Thank you so much. I was trying to learn it for soooo long. You are the Best!
Fantastic tutorial Kevin. 👏👏👏
Hi Kevin, your videos have been really helpful. Can you please also extend this mail merge video if we add some conditions in power automate to send out the emails.
Amazing tutorial, thank you for providing step by step instructions! Question, is it possible to create a hyperlink in the body of the email? I need to navigate the customer to their login client portal. Thank you again!
This has been immensely useful. Thank you. Liked and Subscribed🙂
Kevin, great job. Thank you very much for all videos! You helped me a lot.
Great instructions. I was able to follow and test it with no issues. Ready to configure a similar flow for our users. Thank you.
You are awesome kevin appreciate you for this wonderful tutorial.
Very Many Things!!! I love power automate.
Millions thanks,just want to know more about how to set the conditional rules in mail merge and send out the mass email through outlook and power automatic
Hello Kevin,
thanks for your video! It is amazing what is possible with Power Automate!
I always used VbA (if mail merge was not possible with Word) and my colleague has to create the macros (and she has always done this great, because she is very nice and great in VbA). But now I can do this by myself and I think this will release her to more important projects!
Hi, Kevin! I’m so thankful I found your channel. Do you have a video on how to automate/ send an email reminder from due dates in excel?
Hello Kevin,
Thank you so much for sharing.
This was so great and sending email to those people on the list it looks like BCC because everyone get his/her email content without seeing others email. Great. I was wondering if using this someone will ever need to use BCC as we use it just to hide other receivers' emails?
It's amazing, giving me a lot of time to do other things. I have a question. How do I attach a PDF file with a different name to each email? The files must be in OneDrive alone or Local Computer.
i learnt and applied for the communication i intended. The results was awesome. Thanks.
Kevin, Awesome videos! Thanks for this tutorial! Sending emails has become a matter of minutes. Do you know if there's a way to send a range of emails i.e.: rows 20 to 35 and not the whole list?
This is very useful for me and reduced my complex tasks. Could you please explain how to apply encryption on mail message content and also attachment.
Hi Kevin, thank you for the great content. Can I also personalize who will be CC'ed to specific e-mails?
Great video, very helpful. Is there a way to use Power Automate to save the mail-merged email in drafts first?
I learned absolutely nothing because I was pre-occupied with the price of a box of cookies. Are they gold-plated cookies? Is it that edible spray on gold? Are you the actual cookie monster? Are these deluxe thin mint éxquisite, fudge ripple covered, edible gold tinted delectable cookies? because they're $50 a box.
I'm kidding. Its a great tutorial. 4 years later, I'm still learning. Thanks for all that you do.
Thank you for your lovely video. Very useful information for my job. From London UK
This is so helpful. A few things learned today
May God Bless You Kevin!
Thank you very much, man! Saving hundreds of dollars and tons of time!
Brain is going into vaporlock watching this. Not the video or instruction but learning something new.
This is very powerful 👍
Can I ask if there is a limit for emails? For instance can I send 1000 emails using this tool?
Dear Kevin, Hope you are well. At first a ton of thanks to you for such productive tutorials. I love your content and feel so glad after learning something new.
In this video, I found that the date is not coming in the right format and not showing properly as a date. You can check this out at "15:41". Please let us know how to bring that in the correct format.
Thanks Again.
In excel, format the cell as text. It’ll come through properly then. I touch on this at the end of the video. Cheers!
@@KevinStratvert Sorry that i missed the session after attachment section.
You're Awesome, cheers..!! Love for you from Bangladesh...👍
@@KevinStratvert just to add, I had to add the dynamic content for the related fields again otherwise it still sent the former format and not the new text format. Thanks very much for your great work.
@@KevinStratvert Hi Kevin, this seems like a workaround, rather than a solution. My spreadsheet has hundreds of rows with dates that are used in formulas elsewhere in the sheet. I cannot format as text then manually write the date as text over each one. When formatted as text, the dates appear as, e.g. 45138. There seems to be a way to convert date formats within Power Automate using Expressions (similar to toggling field codes in a Mail Merge), but so far I have not figured out how to do this. Could you perhaps explain how this could be done? For bonus point: not only using Expressions to format the dates to convert 10/22/2020 to October 22, 2020 but also converting 7500 to $7,500 ? thanks!
Kindly make a tutorial on motion animated video with sounds and other effects. There r so many tutorial but ur way of xplaing is best. Please
What an amazing tool!!! Thank you so much!
Kevin you are just great.
I have nothing to say about you. You are just a genius in computer.
But I have a question for you and the question is :
How can I install and use loom - screen recorder on windows. As my school has told to make screen recording on loom - screen recorder in windows 10. Please also show how to install loom (complete tutorial) in windows 10.
Please make withing 8 September.
BTW You are great And I know you will be able to do this.
Kevin, this is an awesome tutorial! I was looking dod a solution like this and this came along.
How can I use this if I want to send birthday wishes to various customers on their birthdays?
Great tutorial, Kevin- how would this work if you had more than one line for a customer, say they bought two different types of cookies, so two lines in the table for each customer? Would they get 2 emails each?
Did you get a response to this? I have something similar and haven't been able to figure out how to insert a table format into the email body.
Thank you so much Kevin, this is extremely helpful. Just curious how do we send customized attachments?
Thank you for this explanation, is it very easy to follow and helpful. I was sent the link to this video from Doug Robbins after asking if a previous video, that showed how to attach bespoke, individual files in mail merge, would work on a Mac. After Doug confirmed it wouldn't, he recommended this video. It does seem like you mention this function is possible, however if you could confirm that would be appreciated. Thanks.
Great mentoring skills mate, clear!!!
This is an excellent tutorial.Thank you so much for sharing! Would you please advise if we could create rich text in the email body (i want to send in a proper email communication template)?
Very helpful. Kevin is great in explaining.
What if we want the attachment to be unique to a specific person/ company.
Does power automate have the capability to search for the unique attachment within a folder and select the relevant attachment for that person/company?
Also great video!
Dear Kevin, many thanks for this useful tutorial video. I was wondering if you could have another video about converting Form response (with attachment as supporting documents) to PDF (custom format) and then email approver for approval (or rejection if applicable) and finally send notification to a form responder about the request status.
Thanks in advance.
Regards, Sothearith
i tried my best and it became a success
Very good video, Kevin.😊
Finally clicking on thumbs up for a reason, thanks Kevin.
beautiful, great and wonderful solution for sending regular monthly emails to customers. can i send invoices to the clients?
thank you for sharing, it is a really great tool to work with. I have a question about this mail merge, Is it possible to mail merge the inbox? I mean when I receive messages is it possible to power automate all the receiving messages in excel? thank you so much