Get the subject and the body of a .msg/.eml file in HTML

Help Studio
, , , , , , , ,
1

Hello,

I need to get the body and the subject of an .msg/.eml file, but the problem is that some of the emails contains a table in body and I would need the body in HTML, because after that I need to send another mail with that body.

I tried a lot of methods from the forum, but none of them works.

Thanks in advance!

2

Hi @darie.leolea

You can launch the .msg file by using use application\browser activity.
Inside of Use application\browser activity use the Extract Datatable activity to extract the table from mail and store in a datatable.

Hope it helps!!

3

Hi @darie.leolea

When you run a For each through the list of MailMessages you can use the below syntax to get the vbody in HTML

BodyAsHTML= currentItem.BodyAsHTML.ToString
Subject = currentItem.Subject.ToString

Regards

1 Like
4

I receive this error: Object reference not set to an instance of an object.

5

@darie.leolea

Can you share the screenshot of the error.

Regards

6

ss_1
ss_11322×102 24.1 KB

7

@darie.leolea

What is emailnet variable can you share the workflow process.

Regards

8

ss_2

9

Hi @darie.leolea

Since emailnet varaible type is of List(MailMessage). You need to run a for each loop to iterate through the mail messages and inside the loop use assign activity and give the below syntax.

Happy to help if you face any difficulties.

Regards

10

The problem is that i don’t read them from Outlook. I have a folder with .msg mails and i read them with for each file in folder. Is there a way to add them to a list of MailMessage so I can use your method ? Thanks!

11

Hi @darie.leolea

Please use the below workflow:

image
image880×1106 55.6 KB

Regards

12

Hi @darie.leolea - you need to read the file from the windows folder this below helps you.

13

Even if I use this method, the string which should read the body is empty

14

Even if I use this method, the string which read the body is empty.