Question

How to call pdf file based on row in excel to the email attachment

  • 23 January 2022
  • 3 replies
  • 1 view

Badge +4

I have a question I hope anyone can help

1) I have list of country in row 3 in an excel, for example "Thailand & India" or just "Korea"

2) For each of that row, if the row containing "Korea" then I want to send email with "Korea.pdf" attachment if the row includes "Thailand” and “India” then I want to send email with “Thailand.pdf” and “India.pdf”

3) The pdf file stated already saved in one folder

4) So how can I call the pdf inside the folder as email attachment accordingly based on country in row 3


3 replies

Userlevel 3
Badge +7

Hi @Nursyakirah Jazlan​ ,

 

You can use three If Actions: String Conditions and nested within them will the the Email: Send Action which references the files you wish to send to that particular individual.

imageKind Regards,

Ashwin A.K

Badge +4

But if there are more 1 country for example there is 10 county involve and there is probability of each of the country is set, so I need to do a lot of if :String Condition ?

Userlevel 3
Badge +7

Hi @Nursyakirah Jazlan​ ,

 

You can split the row item and loop for each item in the list and check if the file exists i.e.

 

Korea & China -(Split on the basis of &)-> {Korea, China}

 

If(File Exists) for each item in list, then send mail else continue.

 

Kind Regards,

Ashwin A.K

Reply