Skip to main content
Question

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


Forum|alt.badge.img+4
  • Navigator | Tier 3
  • 12 replies

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

Ashwin A.K
Forum|alt.badge.img+8
  • Navigator | Tier 3
  • 2445 replies
  • January 23, 2022

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


Forum|alt.badge.img+4
  • Author
  • Navigator | Tier 3
  • 12 replies
  • January 24, 2022

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 ?


Ashwin A.K
Forum|alt.badge.img+8
  • Navigator | Tier 3
  • 2445 replies
  • January 24, 2022

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings