Status

[guptasweb]

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

[Nithinkrishna]

Hey @guptasweb

Where do you want to write it ?

Thanks
#nK

[guptasweb]

in the excel sheet

[fernando_zuluaga]

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!

[guptasweb]

cant we use try catch activity

[Nithinkrishna]

Hey @guptasweb

You are using for each row ?

Thanks
#nK

[guptasweb]

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

[Nithinkrishna]

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

[guptasweb]

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

[Nithinkrishna]

Hey @guptasweb

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

Thanks
#nK

[guptasweb]

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

[Nithinkrishna]

Hey @guptasweb

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

Thanks
#nK

[guptasweb]

[Nithinkrishna]

Hey @guptasweb

Could you please open it and show the table.

I want to see the table format please…

Thanks
#nK

[guptasweb]

[Nithinkrishna]

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

[guptasweb]

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

[Nithinkrishna]

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

[guptasweb]

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…

[Nithinkrishna]

Hey @guptasweb

Try using Sender property and date not extracted meaning pls ?

Thanks
#nK