Explore Courses Blog Tutorials Interview Questions
0 votes
in RPA by (5.3k points)

I want to read all the unRead mails from the mail using "Email Automation Command" and extract the 'from mail', 'subject' and insert into the excel sheet. I am able to read all the unRead mails from mail and subject but here each mail data is inserted into the separate excel file. How can i create the excel file dynamically in Automation Anywhere. Anyone help me.Thanks in Advance.

1 Answer

0 votes
by (9.5k points)

your question can be subdivided as  Creating an Excel file , you can use either VBscript or use csv file 

  and for Reading and writing from Email.

follow the steps 

  • Open spreadsheet
  • Loop through Read mail
  • go to begining of row of active cell
  • set value of active cell{from}
  • go to one cell right to active
  • set value of active cell{subject}
  • go to one cell down
  • end loop

Related questions

0 votes
1 answer
asked Jul 22, 2019 in RPA by noah kapoor (5.3k points)
0 votes
1 answer
asked Jul 17, 2019 in RPA by Abhishek_31 (12.7k points)
0 votes
1 answer

Browse Categories