Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Sending out automated emails with email attachments - with one click



I want to send out 2000 emails with different attachents to each email but these attachments will go out every 3-6 months, the attachments will change every time they go out (emails will stay the same)


So is it possible to fetch the attachments from a document library (or onedrive) and fetch the email addresses which will be stored in a sharepoint library to then send out all the emails with one click.



Super User III
Super User III

Re: Sending out automated emails with email attachments - with one click

@AB1 :


You can use a recurrence trigger to run a Flow periodically such as every X number of months.

Assuming that you have a list of people to whom you want to send emails, you can loop them each one and attach a unique attachment assuming that there is a link of some type between the attachment and the email address.  In other words you need to be able to identify what attachment goes with what email.  The attachments need to be accessible to Flow - having them in a SharePoint library would work.


If you can be more specific, I can provide additional detail.


If this addresses your issue, please mark you post as Solved.

If you like my solution, please give it a Thumbs Up.




If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helper III
Helper III

Re: Sending out automated emails with email attachments - with one click

I cant seem to find an action the lets me 'Get Item' for a document library only for lists 


The link for the documents will be the name, so for instance I have a PDF in my document library called John Smith which I want to link with the email address  (which is in a list) and a column next to the email address will also have the name Ie John Smith so this way I can link both the PDF to the correct email address 


example of the list 

Screenshot 2019-03-26 at 3.13.28 PM.png



As well as linking both the attachment in a doc library and the email address, I want all the the emails to go out all at once (all 2000)


is this possible?


Thank you

Helpful resources

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!


Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!


Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (6,571)