Send Bulk Emails via Outlook from Excel List in Power Automate

[@alenabrahamjacob7866]

The Send an email notification (v3) will send the email from Microsoft PowerApps and Flow. It can only send 100 emails every 24 hours. The Send an email (v2) will send the email from you as the creator of the flow. It can send 300 emails every 60 seconds. there is no single way to send out the bulk emails. You need to break your contacts into maximum group of 300 and wait 1 minute to send out email notifications to next group.

[@ExcelExciting]

Thanks for your reply. I would think of handling it with a counter. That will count number of emails send and when it reaches to 250 or 275 email then we can add delay of 60 seconds. What are your thoughts on this solution?

[@NoelLackey]

@@ExcelExciting what does it limit the amount of emails you can send, working in a university I will have to send an email to 14k how am I going to do that?

[@nateshprabhas2005]

@@ExcelExciting Bro how to create a delay between emails in bulk setup. Please help

[@ExcelExciting]

End of you email just add delay & you need to create counter within the loop that increment by one once email is sent

[@ExcelExciting]

here id detail documentation by Microsoft on the limits docs.microsoft.com/en-us/power-automate/limits-and-config

[@Yogsotothlevrai]

Kudos! Your tutorial is really clear & powerful. I was struggling for two days to make my flow running, and thanks to you it works smoothly!

[@ExcelExciting]

Awesome... Glad it helped! what else you like automate ?

[@jacknichol351]

Thank you so much, what a great video. Worked perfect for me.

[@ExcelExciting]

Awesome

[@MelwynRodrigues]

Nice tutorial Faraz! Thank u! I also liked the 'cockpit' name you used for the 'workspace' area.

[@ExcelExciting]

Thank you..😃 glad to hear you it

[@gikonyondugu7691]

Thank you for this it was helpful

[@sabareshsridaran3668]

Awesome Video! It works perfect for me...Keep up the good work!

[@ExcelExciting]

Thanks a lot.. !! glad to hear you like it..!!

[@himanshubhatt1625]

wonderful...thanks..

[@priyapendyala2439]

Hi thanks Can you please also make a video on how to send micro soft teams message to many users individually (not include channel or group chat )at a time using automate.

[@oneagency4253]

Hi, Thanks for the tutorial can you please also make a video on how to add attachments and pictures on the email body too for bulk emails.

[@ExcelExciting]

Great Idea.. I have log it into upcoming videos list !!

[@Kimwenman]

@@ExcelExciting Have you done this video yet? I wasn't able to find it. Loved this video, very easy to follow. But I do want to include some images in my email body and can't figure out how to do this. Thanks!!

[@4._.9]

Hi Faraz: can this automation expand to send bulk emails to multiple email addresses with multiple attachments?

[@ExcelExciting]

Good question, yes same is possible

[@4._.9]

@@ExcelExciting Thank you for your advice. Would I be able to look forward to a video demo on how to do it? I am using Office 365. My office also does not allow us to install Desktop Power Automate on our office computer. Thank you.

[@akashjain1071]

Thanks for this informative video & wanted to know how can I send out the bulk emails from a mailbox instead of a specific user ??

[@ExcelExciting]

You can change email address of recipient in excel worksheet to send multiple people

[@tonypine6001]

Awesome Faraz, thanks. One question; how would you update the table if you need to edit the list of users?

[@ExcelExciting]

Good question.. you need to use Excel Connector & add action update a row

[@brianTwwjd]

O365 will restrict the account if more then 30 emails are sent per minute. Perhaps send 25 at a time every 2 minutes.

[@lauramackellar9571]

Thank you, Faraz. I got the automation to a certain degree. Can you tell me how to include the excel spreadsheet in the body of the email?

[@chrism2213]

is it possible to send on a schedule with 10-20 different email sender accounts? or do you have to set each flow up individually ?

[@surielcarrasco9175]

Nice video Maste. I've a question about this flow. What if the email registered in the excel table is incorrect or does not exist? How can I create this condition?

[@ExcelExciting]

Good question.. 1. incorrect emails will bounce back.. 2. if you have blank records it is wise to filter the records when your are connecting Excel Table to PA.. by this way you are excluding the blank email ID’s records

[@wmustafa80]

hi Faraz Shaikh, thank you for this tutorial. can you please teach me how to add a read receipt request to this bulk emails automation?

[@jimenaespejo3850]

Hi Faraz! Thanks for the video! Quick question here... I don't see Power Automate within the options in Office 365... how can I get to see it? Regards

[@ExcelExciting]

Do you have home subscription or business one ?

[@heidihesham4202]

hi and thank you for awesome solution, but if the body is a table with performance and different content can it work ??

[@ExcelExciting]

Yes you can create a table and share in email body.

[@lauramackellar9571]

Thank you, Faraz. I'm trying to add the entire excel spreadsheet into the outlook email When I test it - I'm only getting one line of the spreadsheet

[@anuragmalviya7895]

How can we attach a table as a content for each specific user whicj changes accordimg to the users ?

[@ExcelExciting]

You can convert data from the Excel to HTML table and paste it in Email

[@madhu6439]

Hi, Thank you for the valuable video, my doubt is how to attach a Excel file along with email.

[@ExcelExciting]

Will upload soon a video demonstration that.. !!

[@irfansayyed7702]

@@ExcelExciting can you share video on how add attachments in bulk email??

[@thepost1]

how do i add template for this

[@jeansilva9728]

Very good!!! I have a SharePoint list where I have more than one item with a delay status for different managers. I would like to send an email with a table of overdue items to each responsible person with only his items ... Do you have any idea how to do this?

[@ExcelExciting]

You need filter record before sending the email to someone & also make sure the person name is in the list. It is possible with Power Automate.

[@irfansayyed7702]

Is there any template in power automate for bulk email??

[@kdhanasekharreddy7863]

Hi sir Thank you for the video… but I didn’t get the point about what is mean table one and it’s not Comming automatically can you assist me ….

[@ExcelExciting]

You data should be stored into Excel Table, this link might be helpful for you to understand about Excel Table kzbin.info/www/bejne/pJTdoXelltx8apo

[@OutoffOffice]

Hi Faraz, how can I disable the form link once I meet the sample number of responses? If that's not possible than any other alternative to do so?

[@ExcelExciting]

best to my knowledge there is no way of limiting the number of responses, but if you are having O365 work account then you may try to set each person can only respond once and send the end time or you can create a flow that will count the number of responses and reply to the users that number of entries exceeded.

[@Razzy001]

How can I add attachment

[@michelmartell956]

Hi Faraz, great video. Can you please tell me how I can add an attachment (PDF) and also how can I add my corporate signature. I tried with "Get File content" for the attachment, it worked but the name of file sent gets corrupted. Also I haven't figured to add my signature.

[@ExcelExciting]

Hi @Michel, Glad to hear you enjoyed the video. The reason the PDF file might be corrupted the extension might be missing at the end. for your business signatures you need to create one the outlook connector. at the moment best to my knowledge there no way to import your outlook signatures.

[@irfansayyed7702]

@@ExcelExciting can you tell me how to add any attachments like word, excel, pdf in the bulk email??

[@mjem6018]

Hi sir why i cant see the skip, creste cancel button if i click the instant flow what is the problem there. Can you help me. Thanks

[@ExcelExciting]

What kind of flow are you creating ?

[@irfansayyed7702]

Can you please tell me how to add attachments in the bulk email? How to add multiple attachments in the bulk email? Waiting of your reply!

[@rajsonwani1719]

How many emails we can send through office 365 at a time. Is free or paid

[@ExcelExciting]

Send an email notification (v3) can only send 100 emails every 24 hours. Send an email (v2) will send the email from you as the creator of the flow. It can send 300 emails every 60 seconds.

[@datta40]

What are the steps to send follow up email for same list ?

[@ExcelExciting]

hmm, this interesting once.. think of making a video

[@punitha2904]

what is the limit of sending the emails

[@ExcelExciting]

Hi.. this documentation from Microsoft will be helpful for you docs.microsoft.com/en-us/power-automate/limits-and-config

[@irfansayyed7702]

How to send bulk email with dynamic attachment! Please help me for bulk email with dynamic attachments

[@ExcelExciting]

Can you pls clarify more what you mean by dynamic attachments ?

[@irfansayyed7702]

@@ExcelExciting suppose, I want to send invoice copy to my 50 customers. In this invoice copies will be different and customer email address will be different. In this I have given unique invoice number to each invoice. So how I cand send invoice copy to all my 50 customers?

[@Excel-power-users]

How to add multiple attachments to the emails In this process.

[@ExcelExciting]

I will be soon making video on the same as many have request me for that

[@Excel-power-users]

@@ExcelExciting bhai awaiting for the video eagerly

[@capitalcom5008]

How much email can you send per day?

[@ExcelExciting]

Email (v2) will send the email from you as the creator of the flow. It can send 300 emails every 60 seconds.

[@prosenjitghosh3473]

How to send list of orders in one email to a single email id

[@ExcelExciting]

This is interesting, could explain in detail how you like the flow to behave ?

[@prosenjitghosh3473]

@@ExcelExciting For example i need to send 15 orders to a sales rep in one single email ,rather than sending 15 emails to the same person

[@stangetz534]

i can't believe how fucking hard it is to send everyone on your excel list a bulk email.

[@karangori7897]

If a manager has multiple employees on the list, I'd like it to only send them a single email, listing all of their employee or the respected rows

[@ExcelExciting]

Interesting question..!!! pull all the records (emails) into as variable and use that variable in the email address

[@mstootable]

@@ExcelExciting Can you do a video on this?

[@stooeyja]

That works great to send 100 emails to 100 people. How to send one email to 100 people??

[@ExcelExciting]

Hi.. this documentation from Microsoft will be helpful for you docs.microsoft.com/en-us/power-automate/limits-and-config