topic RE: Read text from msg file in Product Forum

Read text from msg file

MateuszWojcik — Mon, 18 May 2020 13:11:00 GMT

Hello,

I work on msg file.

Does any one have action to read whole text directly from msg file?

I have found a solution to converet msg file to txt file and then read text from txt file. I look for shortcut.

Kind regards

------------------------------
Mateusz Wojcik
RPA Programist
Rockwell Automation
Europe/Warsaw
------------------------------

RE: Read text from msg file

PratyushGarikap — Fri, 29 May 2020 10:37:00 GMT

You can use the Get Sent Items action in MS Outlook VBO to read body and other email attributes.

Regards,
Pratyush

------------------------------
Pratyush Garikapati
ROM Architect
Blue Prism
Asia/Kolkata
------------------------------

RE: Read text from msg file

MateuszWojcik — Mon, 01 Jun 2020 14:01:00 GMT

Hello Pratyush,

My case is to read msg file not email.

Kind regards

------------------------------
Mateusz Wojcik
RPA Programist
Rockwell Automation
Europe/Warsaw
------------------------------

RE: Read text from msg file

expertcr — Mon, 01 Jun 2020 15:49:00 GMT

At this moment I don't see out product having that function.
Maybe download a free program to read that file and them BP takes from there what you need.

Have a good day.

------------------------------
Luis Lopez
Customer Support Engineer English and Spanish
Blue Prism Ltd
------------------------------

RE: Read text from msg file

PratyushGarikap — Tue, 02 Jun 2020 03:17:00 GMT

Hello Mateusz,

I misread your original query. You'll have to create a custom VBO to read a .msg file as BP doesn't have that available within its standard VBOs.
Try this and let me know if it works.

Input: File Name (text - full path and name)

Output: Items (collection)

Code:
Dim app = CreateObject("Outlook.Application")
Dim _nameSpace = app.GetNameSpace("MAPI")

'Dim item As Outlook.MailItem
Dim item as Object
item = app.CreateItemFromTemplate(File_Name)

Dim dataTable As New Data.DataTable
dataTable.Columns.Add("To", Type.GetType("System.String"))
dataTable.Columns.Add("CC", Type.GetType("System.String"))
dataTable.Columns.Add("Subject", Type.GetType("System.String"))
dataTable.Columns.Add("Body", Type.GetType("System.String"))
dataTable.Columns.Add("Attachments", Type.GetType("System.String"))
dataTable.Columns.Add("ReceivedOn", Type.GetType("System.DateTime"))
dataTable.Columns.Add("SentOn", Type.GetType("System.DateTime"))
dataTable.Columns.Add("SenderName", Type.GetType("System.String"))
dataTable.Columns.Add("SenderEmailAddress", Type.GetType("System.String"))

Dim row As Data.DataRow = dataTable.NewRow
row("To") = item.To
row("CC") = item.CC
row("Subject") = item.Subject
row("Body") = item.Body

Dim attachments As String = ""
For Each attachment As Object In item.Attachments
If attachment.Type = 1 Then
attachments = attachments & "|" & attachment.DisplayName
End If
Next

row("Attachments") = If (attachments.Length = 0, "", attachments.SubString(1))
row("SentOn") = item.SentOn
row("ReceivedOn") = item.ReceivedTime
row("SenderName") = item.SenderName
row("SenderEmailAddress") = If (item.SenderEmailType = "EX",item.Sender.GetExchangeUser.PrimarySmtpAddress,item.SenderEmailAddress)
dataTable.Rows.Add(row)

Items = dataTable

------------------------------
Pratyush Garikapati
ROM Architect
Blue Prism
Asia/Kolkata
------------------------------

RE: Read text from msg file

MateuszWojcik — Wed, 15 Jul 2020 07:12:00 GMT

Thank you Pratyush Garikapati

------------------------------
Mateusz Wojcik
RPA Programist
Rockwell Automation
Europe/Warsaw
------------------------------

RE: Read text from msg file

PramodPrasad — Fri, 18 Jun 2021 04:32:00 GMT

Hi Pratyush,

I tried the above code and getting 1 error as follows
Stage: Code
Type: Error
Action: Validate
Description: Compiler error at line 1: 'CreateObject' is not declared. It may be inaccessible due to its protection level.
Repairable: No

------------------------------
Pramod Prasad
Consultant
EY
Asia/Kolkata
------------------------------

RE: Read text from msg file

PramodPrasad — Fri, 18 Jun 2021 06:01:00 GMT

Hi Pratyush,

I am getting below error,

------------------------------
Pramod Prasad
Consultant
EY
Asia/Kolkata
------------------------------

RE: Read text from msg file

PratyushGarikap — Fri, 18 Jun 2021 06:08:00 GMT

Hi Pramod,

Are you able to compile the code stage successfully and save the object?

Are you able to open the .msg file manually or do you get an error?

Regards,
Pratyush

------------------------------
Pratyush Garikapati
ROM Architect
Blue Prism
India
------------------------------

RE: Read text from msg file

PramodPrasad — Fri, 18 Jun 2021 06:10:00 GMT

Yes , the code stage has zero errors, and i am able to save the object,
Yes i am able to open the file manually , also tried in other machine i am getting same error

------------------------------
Pramod Prasad
Consultant
EY
Asia/Kolkata
------------------------------

RE: Read text from msg file

PramodPrasad — Fri, 18 Jun 2021 10:34:00 GMT

Let me know if you have solution, one of the mail is copied and kept on shared drive, i will have read that content, so the file format is .msg.
i tried reading using inbuilt action read all text, but getting special characters

------------------------------
Pramod Prasad
Consultant
EY
Asia/Kolkata
------------------------------

RE: Read text from msg file

MateuszWojcik — Mon, 21 Jun 2021 06:04:00 GMT

Hi Pramod Prasad,

Do you receive the same error when the file is save on local drive not the shared drive?

Regards

------------------------------
Mateusz Wojcik
RPA Programist
Rockwell Automation
Europe/Warsaw
------------------------------