Status

how to write status of each file aftr downloading a file from outlook??

1 Like

Hey @guptasweb

Where do you want to write it ?

Thanks
#nK

1 Like

in the excel sheet

1 Like

hey

use the wait for download activity, and then use a write cell activity increasing the counter of the cell ex: “A”+COUNTER.TOSTRING+""

regards!

cant we use try catch activity

Hey @guptasweb

You are using for each row ?

Thanks
#nK

1 Like

no…i m using for downloading a file from outlook mail

1 Like

Okay you download a file using Wait for download as suggested by @fernando_zuluaga

And use Append Range to update status with file name.

Hope this helps.

Thanks
#nK

what to write in the Data Table of Append Range??

1 Like

Hey @guptasweb

It depends on the table columns you need, may be filename column & a status column.

Thanks
#nK

1 Like

thn how can we extract the download status in append range??

1 Like

Hey @guptasweb

Could you please show the excel file in which you are trying to update status ?

Thanks
#nK

excel

1 Like

Hey @guptasweb

Could you please open it and show the table.

I want to see the table format please…

Thanks
#nK

1 Like

File

1 Like

Perfect ! @guptasweb

You will need to create a new data table with three columns as seen in the screenshot.

For every outlook attachment you download, just use add data row to update the status.
Add Data Row will take datatable as input with the column values like { "1.", "File_name", "Success or Failed" }

At the end of the process, just append this data table to your above excel, which should do the job.

Hope this helps.

Thanks
#nK

1 Like

how to take values form download attatchment in data row??

1 Like

Hey @guptasweb

For the filename, you can take from the output of Wait for download activity just save it in a string and pass it to Add Data Row second element.

Thanks
#nK

1 Like

hi nithin
i need some help
in excel sheet i have to add the outlook email details like From,To,Subject,Received date…
but when i use assign activity for From-it shows object reference not to set an instance of object


and second thing it didnot extract the date of mail…pls help me…

1 Like

Hey @guptasweb

Try using Sender property and date not extracted meaning pls ?

Thanks
#nK