Outlook Mail Activity

[Kc.Kumar (Palgun Kumar)]

Hi,
I am trying to extract only a table from the outlook mail body which might be received from different senders and save it to the excel for later use i have attached the example format of the mail which has the table, can someone please send the sample xaml file which stores the table into excel in particular location, thanks.

So the output should be the excel with the values present in table

[Palaniyappan (Palaniyappan P)]

Buddy @Kc.Kumar

This could help you for sure buddy,

Extract data out of body of a mail

Hi all, I’m trying to identify how to extract the data out of this mail and store it as a variable. I need to save “38” as variable “var_age”, “Prague” as “var_City” and so on. The objective is to loop through all new mails with a certain subject, extract the values and write it in excel and then move the file from the inbox folder in Outlook to another folder. Thanks in advance, Kind regards [image]

Extract only a table present in email body

Hi save the email as a .mht file use StartProcess to open the file scrape the data from the table in the email into a datatable write datatable to excel Hope that helps.

Kindly try this and let know buddy
Cheers @Kc.Kumar

[Palaniyappan (Palaniyappan P)]

were you able to get he table buddy
cheers @

[Kc.Kumar (Palgun Kumar)]

No i couldn’t find a solution form these links can you try and share me a xaml file based on my requirement

[Palaniyappan (Palaniyappan P)]

buddy this is te procedure uddy

How to filter messages in Get outlook mail messages

kindly try this and let know buddy
Cheers @Kc.Kumar

[Kc.Kumar (Palgun Kumar)]

Hi Palaniyappan I tried this steps and got stuck the table is not being displayed on browser and one more challenging part is can we open the mail by hiding the browser because i don’t want mail to be opened in a browser

[Kc.Kumar (Palgun Kumar)]

kindly if possible i request you to try the sequence which you mentioned and send me the sample xaml file