Sending multiple pdf files in one mail

(0) Share

Report

Posted on by XRQ57

206

Hi Everyone,

In a folder, i have more than 90 pdf files to send by outlook.

I am trying to send 10 pdf in each email but i don't know how do to that.

Any idea?

thanks

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

This basically makes a separate attachment list for each email; best of luck!

Folder.GetFiles Folder: $'''C:''' FileFilter: $'''*''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> Files
# should actually be set variable %Number% to %Files.Count%
SET Number TO Files.Count
# get the integer part, not rounded (ultimately we will need 1 more loop than this if the decimal amount is not 0
Variables.TruncateNumber.GetIntegerPart Number: Number / 10 Result=> NumofEmailLoops
# Get the remainder by getting the decimal place (only works when the divisor is 10)
Variables.TruncateNumber.GetDecimalPart Number: Number / 10 Result=> FractionalLoop
# We need the fractional number to be a whole number, so multiply by 10; this is the number of PDFs left over for the last run
SET FinalPDFs TO FractionalLoop * 10
# if the pdfs remaining for last run is anything but 0, add 1 to the amount of email runs
IF FinalPDFs > 0 THEN
SET NumofEmailLoops TO NumofEmailLoops + 1
END
# create a list to temporarily hold the attachements that we are going to add
Variables.CreateNewList List=> Attachments
# this is going to hold the index of %Files% at which attachments left off
SET CurrentPDF TO 0
SET PDFMax TO 10
# Loop 1 to Number of Email Loops
LOOP LoopIndex FROM 1 TO NumofEmailLoops STEP 1
# create a list to temporarily hold the attachements that we are going to add
IF LoopIndex = NumofEmailLoops THEN
SET PDFMax TO FinalPDFs
END
LOOP AttachmentsLoop FROM 1 TO PDFMax STEP 1
Variables.AddItemToList Item: Files[CurrentPDF] List: Attachments
END
# send email here with attachments
Variables.ClearList List: Attachments
END

Was this reply helpful? Yes No
XRQ57 206 on at

Like (1)

Report
Copy link

Link copied!

Hi Michael,
Awesome solution!
Thank you.

I have made a modification because it was always the same file in the email (10 times the same).
I think we need to increase CurrentPDF by one in the loop which is the number of the file in the list.

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

Like (0)

Report
Copy link

Link copied!

You are absolutely right. I meant to put that in there and forgot. Good catch.

Was this reply helpful? Yes No