Extract details and download attachment from .msg

Help Studio
, ,
1

Hi team,
I am going through this process where I have .msg file and its has table in the body and attachment on the mail how to extract the table and how to download the attachment from .msg file.

2

Hi

Have a look on to these threads

Cheers @Majunu09

3

Hi @Majunu09
For this u can use a c# code to convert a .msg file to mailmessage object and then u can be to extract the attachemnts

Refer this link for more information on that
https://www.codeproject.com/Articles/32899/Reading-an-Outlook-MSG-File-in-C

Regards,
Nived N

4

@Palaniyappan
Can you explain me on the process " Read a.msg file and save attachment"?

5

@NIVED_NAMBIAR is there any other way caz I am not much in code…

6

check this

I think this would work your case, converting a .msg file to mailmessage object

7

The code shared in that thread can be used in a INVOKE CODE activity

@Majunu09

8

@Palaniyappan , can you guide me,?
should I copy all the code("Dim OlApp
Dim Eml
Dim Arg
Set Arg = WScript.Arguments
Dim File

File = Arg(0)

Set OlApp = CreateObject(“Outlook.Application”)
Set Eml = OlApp.CreateItemFromTemplate(File)
Download(Eml)

Sub Download(objEml)
For Each Attch In objEml.Attachments
Attch.SaveAsFile “C:\temp" & Attch.FileName
Next
End Sub”) and apply on invoke code activity?
and what will be next step?

9

You can either pass this on INVOKE CODE activity or write in a notepad and save the file with .Vbs extension

Dim OlApp
Dim Eml
Dim Arg
Set Arg = WScript.Arguments
Dim File

File = Arg(0)

Set OlApp = CreateObject(“Outlook.Application”)
Set Eml = OlApp.CreateItemFromTemplate( File )
Download(Eml)

Sub Download(objEml)
For Each Attch In objEml.Attachments
Attch.SaveAsFile "C:\temp\" & Attch.FileName
Next
End Sub

Here mention your filepath and once been saved as a file
Get the filepath of that file and pass it to START PROCESS activity as input and mention the argument like this
image

Cheers @Majunu09

10

@Palaniyappan I am getting this error.

vberror
vberror1366×768 95.3 KB

11

@Palaniyappan @NIVED_NAMBIAR is there any other way to download the attachment in .msg file can you share screen shot or xaml file?

12

Hi @Majunu09
There is a way to try this but u had to use third party packages

It will works

First Install the below nuget package
image

From package manager.

Now use the below assign activity

mail_1 = Aspose.Email.Mapi.MapiMessage.FromFile(file_path of the msg file)

datatype of mail_1 : Aspose.Email.Mapi.MapiMessage

Then to access the subject (for example ) u can use

mail_1.Subject -----> will give u the subject of the mail in msg file.

Try this and let me know if it works for u as wellMain.xaml (4.5 KB)

use the above by installing the above dependencies

Hope this will help u

Regards,
Nived N

13

@NIVED_NAMBIAR thank you for the reply,
I get the subject of the msg file but how to download that attachment which is inside of it.

14

@Palaniyappan Hi dude,
can you help me out on automation caz i still unable to download attachment.

15

Hi @Majunu09

Glad to know that it worked out for you

See what u get is a varaible which is simmilar to functioning of mail message

Now to get the attachment from a varaible u can use the simmilar how u download the attachment in UiPath from mail message varaible

Check out the video

Regards

Nived N :robot:

16

@NIVED_NAMBIAR Hi dude,
its not outlook mail, its about .msg file. .msg file has attachment and we need to download the attachment.

17

I mean after the assign activitiy it becomes like mail message type itself

19

@NIVED_NAMBIAR Hi dude, I have no idea can you share the xaml.

20

@Palaniyappan Hi dude can you share an xaml file to download .msg file attachment

21

I got to see a component on this from UiPath marketplace

Pls have a view on it

Cheers @Majunu09