Attached different files & send to different email addresses

(0) Share

Report

Posted on by foxngn84

Hi All,

Would like to know if I want to send email with unique attachment to different recipient,

what is the easiest & best approach to do so?

Currently I only being able to set it send to different recipient, but I failed to set it to attached different files to different email address.

All the files will be stored under the same folder.

Thanks

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

Sort by

momlo 1,527 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi
You need to move Get Files used for setting up %files% variable under the loop since you want to make it dynamic per recipient. Then this action needs to be getting files from different folder so instead of hardcoding the folder path you need use variable that you will set based, for example on the excel column "folder" as you do with recipient.

Was this reply helpful? Yes No
foxngn84 95 on at

Like (0)

Report
Copy link

Link copied!

Meaning, in order for it to work properly, i have to store each attachment per each recipient in their own individual folder, then I specify each path in the excel file?

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

1. Do the filenames exist in Excel?

if yes, pull them into the datatable and reference CurrentItem[filename]
if no…

2. Is the table in the same order as %Files%?

If yes, use a Loop from 0 to %Files.Count - 1% increment of 1. Now Instead of %CurrentItem[ColumnTitle], you will use %Email[LoopIndex][ColumnTitle] and can use %Files[LoopIndex]%.
if no, then where are you correlating an email/subject to an email address? Is it in the filename?

let us know, but definitely possible.

Was this reply helpful? Yes No
foxngn84 95 on at

Like (0)

Report
Copy link

Link copied!

1. Do the filenames exist in Excel?
A: the filenames is not exist in Excel, as this will be a bi-weekly routine, and the filename will be change each updates, thus I'm thinking to not put inside the excel data.
if yes, pull them into the datatable and reference CurrentItem[filename]
if no…
2. Is the table in the same order as %Files%?
%Files% only consists of the files I want to attached to email.
If yes, use a Loop from 0 to %Files.Count - 1% increment of 1. Now Instead of %CurrentItem[ColumnTitle], you will use %Email[LoopIndex][ColumnTitle] and can use %Files[LoopIndex]%.
if no, then where are you correlating an email/subject to an email address? Is it in the filename?

I try to elaborate further.
Every 2 weeks I need to compile about 50 emails to 50 individual with unique files.
Each email subject will contain a unique value, eg : Biweekly report January 2023 Section TCH
& the files that attached will be name as example : BCG(Section TCH) 01.pdf

My plan is set PAD to grab each files and send out in ascending order, my compromise here is, i intend to add numbering in front of the files, such as 01.BCG(Section TCH) 01.pdf so that PAD able to recognize and send the files according to the ascending order of the email list.

Currently my excel file only got 2 column.
I want PAD to send steve@test.com with the files 01.BCG(Section TCH) 01.pdf
Then continue to send jason@test.com with the second files starting with 02.
while ron@test.com with the third files starting with 03.

Thanks

Was this reply helpful? Yes No
foxngn84 95 on at

Like (0)

Report
Copy link

Link copied!

I can set multiple folder for each files. But if each file I send out, the file name is dynamic.
I insert a folder column into my excel(which contain folder path only(file name not included)for each email recipients, and I add it into a list.
Inside the send email through outlook activity, what should i set on the attachment field so it could get files inside those folder instead?

Was this reply helpful? Yes No