Hi RPA Developers! Currently, I am working on a completion status that tracks whether I have sent out an attachment through email or not. Any suggestions on how I can do this? Cheers!
Yah once after sending the email we can update that process completion as a status in excel file
like in the sequence first use a BUILD DATATABLE ACTIVITY and create two columns in it both with string type named EmailSubject, Status
and get the output with a variable of type datatable named Finaldt
now after sending the email we can use ADD DATAROW activity where mention the input in ArrayRow property as {“your mail subject”,“Mail sent”} and in datatble mention as Finaldt
this will add a row with value in datatable Finaldt
now use a WRITE RANGE ACTIVITY and mention the input as Finaldt and enable ADD HEADERS property and mention the filepath of the excel where we want to save this data
Cheers @S.Varnakam