Greetings of the day…!!!
I am writing the mail id and date of the sender from outlook to an excel sheet and adding status as success or failure to check for an attachment present. I am using build data table activity to create a table and add data row activity is used to add the mail id and date of the sender, Write range activity is used to write the data in excel and output data table is also created. Now I am facing the problem of overwriting. I have three key skill in excel such as java developer,rpa developer, and associate software. so the code checks for each keyword in the subject line and downloads the attachment. while I am trying to write the data about the downloading file in an excel only the last key skill that associate software is alone getting written on the excel. how can I write all the details about the attachment in an excel.
Please help me with this case…