topic Read Outlook Email Body in Product Forum

Read Outlook Email Body

MohanV — Tue, 29 Nov 2022 00:53:30 GMT

Dear Experts,

I am trying to read Outlook Email and insert insert into DB table, I am able to load all other fields except Email Body as it's reading as HTML. I tried to use below Regex to handle the issue but no luck.

Output = Regex.Replace(Body, "<[a-zA-Z/].*?> (Text)", String.Empty);

Appreciate if any advise for any other way handle this issue so that I can get only text portion of Email body.

Note: I am already using the latest VBO for Outl0ok.

Best
Mohan

Re: Read Outlook Email Body

Soumya21 — Tue, 29 Nov 2022 04:12:50 GMT

Hi @MohanV

You can take email body in text also by modifying code
In VBO change the one line of code in internal get items action
in that replace this one line of code row("Body") = If(item.BodyFormat = 2, item.HTMLBody, item.Body) with this row("Body") = item.Body
It will fetch you email body in text.

Thanks,
Soumya

Re: Read Outlook Email Body

MohanV — Tue, 29 Nov 2022 04:48:56 GMT

Worked like a Charm. Thank you Soumya kalal.