Send Mass Emails (Gmail or Outlook) From Excel Automatically, With Attachment Based on Excel List

🕒 Timestamps:
00:00 Introduction
00:46 House your data in an Excel table
01:10 Create a flow in Power Automate
02:02 Specify the location of your Excel workbook
02:39 Loop through each file in the attachments folder
04:38 Draft the email
06:56 Attach a file to the email
07:52 Install the Power Automate Add-in and activate the flow

💡 Why this is useful?
- Automate your email marketing tasks.
- Personalize attachments based on recipients.
- Save time by leveraging Excel data.

👍 If you found this tutorial helpful, please give it a thumbs up, share it with friends, and subscribe for more tutorials like this!

💬 Comments or questions? Drop them below, and I'll do my best to respond.

#excel365 #PowerAutomate #email #exceltips #exceltutorial

[mikevanwieringen]

Excellent tutorial, Chester....This will certainly come in handy...Thanks for posting

[agepab]

Thanks for a great tutorial Chester! It helped me a lot. Had just a little strange problem, It will only send to the first 18 rows. Had about 150 employees so I had to add 18 at the time to my list and run Power Automate. Then delete and add new 18 entries. Tried several things to get it to fully work but gave up and just added 18 and 18 and 18 .... :) Anyone else have this problem?

[bero]

Thank you, the first time it’s worked but unfortunately when I tried it doesn’t work again!

[cagilben]

Thanks for this helpful tutorial video. A little question; I want to attach the student reports and certificates, which are in two different folders, to the same e-mail. How can I do that?

[christophwissing]

Thank you . I’m interested in a vba macro code with attachent and with a table range based in the body html . Is this possible ?

[marino]

Hello Chester, I followed the tutorial step by step and at first it worked ok. The issue is that it now takes a long time to send emails (approximately 40 minutes). Is there any way to reduce this time?

[contactsri]

Hi chester can we send zip files using this techinque?

[juliamacha]

Hey! Does anybody know what should I do to send multiple attachments? I have no idea how can I modify my excel spreadsheet and flow to do that. Thanks!

[stephanienash]

Thank you very, very much for this easy to understand tutorial that appears to work when tested and ran.
My problem seems to be that the emails are not coming through and I can't work out why. It has been about 2hr since I sent them. (I've checked the addresses etc. - they are my address and that of my family. Would you please be able to give me any advise or help please. I am trying to find out from Google too; I'm not just massively lazy asking you.)

I don't mind if the emails take 24hr to come through - but longer than that would be an issue for what i'm trying to achieve.

Thanks again for this - brilliant video - I have been working on this problem for days and days, using variable methods.

[odettebellanero]

What should I do, when the list of people on the excel needs to receive the same files. Which step should I ignore and which one I should add. Thanks