Can we get the Unread mails and store its contents into excel

Learning Hub
, , , ,
1

Hey,

I’m extracting unread mail through “Get IMAP Mail Messages” from gmail.

I want to store the “From”, “Body”, “Subject” in Excel sheet.
I had 3 new Added new columns via “Add new column” and named them as “From”, “Body”, “Subject” and store the respective information in the columns.

I’m facing difficulties in storing the information in excel. Is there any way out?

Thanks in Advance!

2

Hi @ray_sha,

There is better way to store into Excel.

image
image1325×650 32.7 KB

  1. Build Data Table activity to create a DataTable with three columns “From”, “Body”, “Subject”

image
image1841×734 43.6 KB

2. For every email extracted Add Data Row activity

image
image1253×529 20.2 KB

3. Write Range activity to read from the Excel data table and store to Excel

Please note that Excel automation is also covered in UiPath Academy - RPA Developer Foundation.