I have a folder containing all pdf files
and a excel with a list of email address. pdf file name consist of the ID(in bold) to match to email list. How can i pick the pdf file based on the ID and attach in a outlook email. Might have multiple attachement
You can try like this
Hope the id will be in a variable
Use this expression in your outlook attachments
Thanks for the reply, would this work with multiple attachments with the same ID?
would like to attach multiple attachments sending to the same email address
PAss like this in the attachment collection
You can use the above expression it is returning the multiple files
tested with multiple formats you can just test with .pdf as mentioned in the above expression
Note : Kindly remove the expressions used in the attachfiles wizard as we are going to use attachment collection
i have receive this error,
Send Outlook Mail Message: Index was outside the bounds of the array.
Can you share the screenshot @rayz1503 ?
from the Send outlook activity?
this is what i used on the AttachmentsCollection properties
What is the value of the strPath? @rayz1503
change the expression like this and try again
it is just a path to my D drive. Using assign to declare
Have you tried with this updated expression? @rayz1503
still getting the same error
Keep a message box before the send outlook and give this expression and check if you receive any file names
Use like this in attachment collection @rayz1503
still getting the same error.
A little more context
- 2000001457_019846427044000 e034d9c9-a8b6-46dc-a0e8-9bb27383f71e.pdf
item 1 and 2 would be sent to say email address [email@example.com
for item 3 would be a different email address firstname.lastname@example.org as the ID is different
I have tried and it is running and sending the attachment as per the ID @rayz1503
could u kindly send the xaml file? thank you