mail merge flow with unique attachment

(0) Share

Report

Posted on by amirattia12

Hi Everyone,

I really need your help in order to setup an automated process through flow. I really think that this could be done through ms flow, but I can’t make it happen so far. As I am not an experienced user any suggestions are welcome and appreciated.

Target.

send more than 1K pdf's , 1 file to one unique email

my understanding is :

like mail merge.

I got excel sheet with all my dynamic content for the email with file name in each row

File	email	info	ID	Name	Surname
Mai	skffir@email.com		11	Mai	Elbeltagy
Nadine	djdsdkdsv@email.com		13	Nadine	Bahgat

PDF files are saved on Onedrive in a folder

What I achieved so far:

I could make a flow to send all emails with dynamic content to all recipients with one file using "Get File Content"

tried different things but i end up with sending all files that are on Onedrive to all recipients

I need help with making the flow to send 1 file only to each row in my excel sheet.

Thank You

my flow.png

All responses (2)

Answers (1)

cwijayd 2 on at

Like (0)

Report

Re: mail merge flow with unique attachment

Hi,
I am trying to do the same, send email to hundred people own attachments.
I manage to follow the step, but I don't know why at the end my flow not RUN, the icon RUN I grey while the others are blue.
Verified answer

amirattia12 15 on at

Like (3)

Report

Re: mail merge flow with unique attachment

Hi Everyone, 😀
I managed to get it after a lot of research here on this forum,
and after 52 or more trial and fails runs
I'll post my final flow here for anyone who might need it in the future,
Many Thanks to you all

😀