Saving and Reading excel attachment from mail

Automation Studio
,
1

Hi,

I am able to search mails in Automation Studio. After searching, when I read the mails all the components (subject, body, attachments) are saved separately in a folder named same as “Email Entry Id”.
Ex: C:\Users\RPA\EmailOutput\000000007750B32F2EAD674693ECCD7D7A10835B0700E24E97CEF1D663478CF5515E9306CD7C00000000010C0000E24E97CEF1D663478CF5515E9306CD7C0002A96735AD0000
Subject and body of the mail is saved as .txt file while attachment is saved as excel file.

I need help in following tasks:
1.) Reading the attachment excel file
2.) Copy/Move it to another folder.

I was able to copy the excel file but it was copied with its parent(Email Entry Id) folder.
Ex:C:\Users\RPA\EmailProcessed\000000007750B32F2EAD674693ECCD7D7A10835B0700E24E97CEF1D663478CF5515E9306CD7C00000000010C0000E24E97CEF1D663478CF5515E9306CD7C0002A96735AD0000\attachment.xlsx

I only want to copy attachment.xlsx in EmailProcessed folder.

Thanks
Kunal Gaurav

2

Hi,

You ca use Excel Recorder activity to perform required operation on the excel
Use File Copy interaction to copy file

Regards,
Amit

3

Hi Amit,

The path of saved attachments becomes so long due to email entry id being appended in the output folder that I am not even able to open the file either in AE or by double clicking the file.
I am getting the error “Make sure that the file has not been renamed, moved or deleted” in both the cases.
The path of attachment looks like:
C:\Users\RPA\EmailProcessed\000000007750B32F2EAD674693ECCD7D7A10835B0700E24E97CEF1D663478CF5515E9306CD7C00000000010C0000E24E97CEF1D663478CF5515E9306CD7C0002A96735AD0000\attachment.xlsx

Any help??

Thanks
Kunal

4

Hi,

Try to rename it to some shorter name

Regards,
Amit