How to Mail Merge using Power Automate
266,386
Published 2020-10-02
š Additional resources:
- Introduction to Power Automate: Ā Ā Ā ā¢Ā PowerĀ AutomateĀ TutorialĀ forĀ BeginnersĀ Ā
- How to Mail Merge using Word, Excel, and Outlook: Ā Ā Ā ā¢Ā HowĀ toĀ MailĀ MergeĀ inĀ Word,Ā ExcelĀ &Ā Ou...Ā Ā
- How to Mail Merge Address Labels: Ā Ā Ā ā¢Ā HowĀ toĀ MailĀ MergeĀ AddressĀ LabelsĀ -Ā Of...Ā Ā
- How to Mail Merge using WPS Office: Ā Ā Ā ā¢Ā HowĀ toĀ MailĀ MergeĀ inĀ WPSĀ OfficeĀ Ā
ā Timestamps
0:00 Introduction
1:49 Log into Office.com
2:22 Enter Merge data into Excel Online
5:44 Open Power Automate
6:49 Create a new Mail Merge flow in Power Automate
8:25 Add Excel sheet to Power Automate
10:05 Select email provider, whether Outlook or Gmail
13:24 Customize to, cc, and bcc
14:20 Run Mail Merge
15:35 Preview results
15:45 Include attachment
17:58 Preview results
18:33 Format data properly in Excel
19:25 Wrap up
š© Connect with me on social:
- LinkedIn: www.linkedin.com/in/kevinstratvert/
- Twitter: twitter.com/kevstrat
- Facebook: www.facebook.com/Kevin-Stratvert-101912218227818
š Subscribe to my YouTube channel
youtube.com/user/kevlers?sub_confirmation=1
š¬ Want to watch again? Navigate back to my YouTube channel quickly
www.kevinstratvert.com/
All Comments (21)
-
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.
-
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.š
-
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!
-
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.
-
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! :)
-
Your videos are by far my favorite for Microsoft productivity. Practical examples that are concise and useful.
-
Great service for the fellow human professionals. Thank you so much dear @Kevin Stratvert for your selfless support and training for the needy people!
-
Kevin, your videos are so awesome. This mail merge will help us every month. Thanks!
-
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.
-
Great video again Kevin, many thanks! As some other people asked as well Iād love to see how to do customized attachments
-
You have no idea how much you are helping us!!! Thanks
-
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
-
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.
-
Very very helpful. Thank you Kevin. You make everything so easy to understand.
-
Kevin, great job. Thank you very much for all videos! You helped me a lot.
-
You are only one Youtuber (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 ^_^
-
Great instructions. I was able to follow and test it with no issues. Ready to configure a similar flow for our users. Thank you.
-
Wow! this is great information. I just started my own project with this tutorial. Thank you!