Open outlook email, Open attached Txt file, Read Data in text file and copy data to Excel

Help
1

Hi All,

I am very new ti UIpath. I need to open a text attachment in outlook email which is scheduled daily. Read the data from text file and write the data to a excel file.

This email is a scheduled email which comes in daily, so data need to be written into excel on a daily basis. For example data from feb 3 email attachment need to written under feb 3 under excel and so on.

Sample text file and excel.

image
image1061Ɨ696 113 KB

Kindly provide ideas and examples.

Thanks in advance.

Regards,
Ram

2

Hi All,

Can anyone help?

3

Hi @ram_ch

See these

Thanks,
Prankur

2 Likes
4

Hi @ram_ch

1.save Attachement
2.Read text file
3.Use Extract Structured data activity for this input is string and output is data table

hope it will help

1 Like
5

Can someone kindly provide example file?

6

Anyone can please help?

7

Hi @ram_ch,

Please find the attached workflow which i have created as per the mentioned problem.

And do update your emailID in the variable ā€œemailAddressā€.

ReadDataFromText_WriteInExcel.zip (1.9 MB)

Let me know if you have any query.

Regards,
Suman