How to write outlook mail body table to excel file

[Ramya1 (Ramya)]

Hi,

I am beginner in Uipath. I am trying to extract table from mail to excel.

Table looks like this.

I have already gone through How to write email body table to excel file link but didnot understand the solution completely.Can someone explain me the process or share me the xaml file to extract the data.

[priyankavivek (priya)]

try them using split function

[vikas_reddy_Vicky (Vikas Reddy Kapu)]

This post seems similar to your’s

Extract data out of body of a mail

It is achievable. Follow the below process. Read Email based on Subject filter like: “[subject]=‘Uipath demo’” . more details here How to filter messages in Get outlook mail messages: Use option : Unread Email You will get an out List say mailList, so you can use forEach mail in the mailList, do the below: … a. Use Save Mail Message : pass mail, to: “temp.mht” … b. Use Start Process, pass “temp.mht”. This will open the mail in the browser … c. Use data scraping and scr…

[Ramya1 (Ramya)]

Vikas,

It helped me but i need content of multiple mails with same subject line into one excel.Can you help me out.

[vikas_reddy_Vicky (Vikas Reddy Kapu)]

@Ramya1

content of multiple mails

Columns, rows of table remains same? If yes, use ‘for’ each email and scrape the data as required.

@Ramya1

same subject line

for the same subject line, refer below

Get Outlook mail messages filter gets only the first or the earliest email matching filter condition

Get Outlook mail messages activity property ‘filter’ when set gets only the first or the earliest email matching that filter condition. It does not get all the emails.

How to set filter on 'Get Outlook Mail Message' to only process eMails with attachments and Subject containing a certain number of delimiters

I’m trying to figure how to set Filter so only an eMail with an attachment and having a subject that contains three values separated by a common delimiter is processed. I’ve not seen any posts related to filtering on number of attachments in the eMail. Any ideas?

[soorya_prasad]

Hi @Ramya1 You can use save mail message acttivity and save it as .mht format and use start process to open the mht file and scrap the data using data scraping.It will have output datatable. you can use write range to write in excel.