Skip to main content
U
usernsj
Navigator | Tier 3
January 23, 2022
Question

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

  • January 23, 2022
  • 3 replies
  • 92 views

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
    Ashwin A.K
    Navigator | Tier 3
    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

    Blogs at TheCodingTheory - https://www.thecodingtheory.com
    U
    usernsjAuthor
    Navigator | Tier 3
    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
    Ashwin A.K
    Navigator | Tier 3
    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

    Blogs at TheCodingTheory - https://www.thecodingtheory.com
    Terms & ConditionsAccessibility statement