Skip to main content
Cadet | Tier 2
September 1, 2022
Question

Hi All, I am downloading all attachments and saving in a particular folder .While doing this all the sender Email id 's are in a dictionary variable.So how can i get that Email-id's into Excel

  • September 1, 2022
  • 4 replies
  • 218 views
Hi All, I am downloading all attachments and saving in a particular folder .While doing this all the sender Email id 's are in a dictionary variable.So how can i get that Email-id's into Excel

    4 replies

    Cadet | Tier 2
    September 2, 2022

    thanks a lot ashwin.With this excel i am having another master data in which all the mail id's are available along withsome data and i need to change the name of the downloaded excel attachment with some column in master file by validating the mail ids .

    can you please explain

    Ashwin A.K
    Navigator | Tier 3
    September 2, 2022

    Hi @mahesh ch​ ,

     

    I've answered a similar question here(link), please have a look and let me know if it satisfies your requirement.

     

    KInd Regards

    Ashwin A.K

    Blogs at TheCodingTheory - https://www.thecodingtheory.com
    Ashwin A.K
    Navigator | Tier 3
    September 2, 2022

    Hi @mahesh ch​ ,

     

    Add the email ids and attachment names to a Dictionary.

    Next, loop for each row in the Master Dataset and validate whether the Key exists using the Dictionary: Get Action.

    If the key doesn't exist, it will return null.

     

    You can frame the rest of the logic into this.

     

    Kind Regards,

    Ashwin A.K

    Blogs at TheCodingTheory - https://www.thecodingtheory.com
    Cadet | Tier 2
    September 2, 2022

    Thanks a lot ashwin

    how can we add email id and attachment names to a variable.and can u elaborate for clear understanding to solve this