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

Рет қаралды 15,358

Күн бұрын

📌 In this Microsoft Excel tutorial, I'll show you the step-by-step process to send mass emails either via Gmail or Outlook directly from your Excel sheet. And yes, automatically attaching files based on an Excel list! If you'd prefer a VBA solution, please see • VBA to Automate Sendin...
🕒 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

Пікірлер: 14

@mikevanwieringen9883 11 ай бұрын

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

@agepab 5 ай бұрын

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?

@bero3249 27 күн бұрын

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

@cagilben 2 ай бұрын

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?

@christophwissing4877 10 ай бұрын

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 ?

@marino182 10 ай бұрын

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?

@contactsri81 10 ай бұрын

Hi chester can we send zip files using this techinque?

@juliamacha1028 6 ай бұрын

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!

@stephanienash3093 7 ай бұрын

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.

@stephanienash3093 7 ай бұрын

Don't worry - I've done it!!! (not that you were worried). I can't thank you enough!! I've waster about 72hr of my life on this (unpaid). I'm not a computer person. YOU WERE TO ONLY PERSON AND INFORMATION THAT HELPED ME AND WORKED. THANKS AGAIN!!! YAY!

@teodoraniculescu133 4 ай бұрын

Hi, i keep having the same issue…can you please let me know what you did in the end to solve this??? I am really curious. Thank you in advance.

@financetips 26 күн бұрын

@@teodoraniculescu133get paid version 😅