Outlook Mail Activity

[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