Send Outlook Mail Message for Dynamic Pdf Files

Help Studio
, ,
1

Hi guys,

I want to create process about sending dynamic pdf files to different person e-mail adresses to.

I create one excel file with name “brainofmails.xlsx” then create a loop with for each row from excel data to get file names and email contacts. But when ı try to send dynamic pdfs to different emails in excel file , there is nothing. I cant see mail results.

My process like this ;

I’m using this excel format for get datas from excel ;

image

1- Assign pdf files path to variable ;

image
image789×195 5.42 KB

2- Read Excel Datas in Excel Application Scope ;

image
image762×356 10.8 KB

3-For Each Loop ;

image
image725×386 13 KB

4- Attachment side for dynamic build ;

image
image1039×131 6.49 KB

Thanks alot,
Best Regards,

2

maybe silly question but it is ensured that the email is not sent to xyz@gmail.com

3

Dude , its’a sample :slight_smile:

4

sure but can happen :slight_smile:
in general your worflow looks fine on the first look
maybe you split the analysis

  • send only email without attachment
  • send email with hardcoded path
  • check again the fully dynamized implementation
5

I already try this analyse method bro. But there is no fix yet :frowning: Is there any suggestion ?

Thanks.

6

when you attach the file, can you try this instead:

path.combine(pdflist,row(0).tostring.trim)

7

Thank you so much, I fix it.