How to read the table data from the outlook Email body

Help Activities
, , , ,
1

image
image1001×259 9.03 KB

image
image1280×405 16.5 KB

Mails.zip (31.1 KB)

I need to read the CR Amount and Reason Data from the Table.

Bank: 288

The following 1 ACH batch for **NBR LLC Payables (Company ID: ****61488) requires your attention:

CR Amount CR Count DR Amount DR Count Settle Date SEC Entry Desc Reason(s)
$63,475.01 13 $0.00 0 6/7/2023 PPD AchBatch Suspend: Prefund Suspend

Do not reply to this message. If you have any questions about this alert, contact FIS Client Care Support 844.6 FIS NOW or 844.634.7669. Please have your Entity ID available for security validation.

I have attached two Different Email Messages in both the Different Emails I need Cr Amount and Reason.

Thanks,
Nitesh S

2

HI @nitesh.s

Welcome to UiPath community

check out this video link

Regards
Gokul

3

@nitesh.s

Read the email body as HTML body…and then save the body on text file as .html file and open the .html file in browser using use application/browser and then use extract datatable activity

mail.Headers("HTMLBody")

cheers

4

Hi @Gokul001 ,

Thanks for looking in to it.

we are building the Unattended solution.

There is a dependence of the Outlook Application the for the Solution you shared.
In our Unattended Servers we don’t have Outlook Application. we are making use of Graph API for Mail Activates.

Is there any alternate solution for my problem.

Thanks,
Nitesh S

5

Hi Ani,
can you please share the screen shot.

am getting an error while writing it to text file Activity as .html file

Thanks,
Nitesh S

6

@nitesh.s

Your string will be mail.BodyAsHTML and file would be test.html

Can you please show what you tried

Cheers

7

https://forum.uipath.com/search?q=table%20from%20email