Check for Table data in mail body

[Pranay_Kumar_Bose]

Hello All…
I have a requirement where I need to check for and extract a table data else send a reminder…

As u can see in the image there is note and a table…

I am able to extract the note part into a seprate sheet and further I need to check for the table and extract it…
I am also able to extract the table but unable to get an “if” condition to check for the table is present or ont in the mail body.

Thanks and Plz excuse typos

[Quenton_Wayne_Rebello]

Since the Month word is present only in the table, you can check if Mail Body contains Month while extracting mail message

[jack.chan]

you can try this custom activity @Pranay_Kumar_Bose

Extract Tables from Mail - RPA Component | UiPath Marketplace | Overview

[postwick (Paul Ostwick)]

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

[Vikas_M]

Hey @Pranay_Kumar_Bose ,

Please refer below thread for a solution

How to extract table data from mail body?

Hi There are multiple approaches to read a DATATABLE from a mail body Like data scrapping or converting the HTML mail body to DATATABLE Have a view on this thread for multiple approaches Or This component can help you convert the HTML to datatable that is it will read the mail and give the datasets in it If you using this component Then the steps involved will be like [image] [image] In property HTMLText – item.Header(“HTMLBody”).ToString . This will extract the HTML code from the e…

[Pranay_Kumar_Bose]

Thanks to everyone for the reply, but as I said above, I was able to extract the table from the mail.
The previous requirement was just to extract the tables from the mail, now the requirement is first to check for the table and then extract else send a reminder mail…

[Pranay_Kumar_Bose]

@Quenton_Wayne_Rebello
Ya I have done like this only, but posted in forum for if any better approach.

[Anil_G (Anil Gorthi)]

@Pranay_Kumar_Bose

How are you extracting the table using table extraction?

If so then first use check app state to check if exists

Cheers

[mkankatala (Mahesh Kankatala)]

Hi @Pranay_Kumar_Bose

=> You can use the save mail message activity to save the mails as .mht file.
=> Take Use application\browser activity to open the .mht file.
=> Insdie Use application\browser activity insert the check app state activity and indicate the table in the mail body.
=> In Target appears block insert the extract datatable activity to extract the table as datatatable and you can write the datatable in excel by using write range workbook activity.
=> In Target does not appear block Insert the send outlook mail message activity to send a remainder mail to the receipients.

Hope it helps!!