topic Saving Outlook emails in Product Forum

Saving Outlook emails

JamesBarrett — Fri, 22 Jul 2016 18:57:00 GMT

I was wondering whether anyone has developed an object action to Save emails / Move emails to a network folder? I'll look at trying to create one if not, but I'm not an expert with VBA. The Move Email action within the MAPIEx VBO appears to be limited to moving files to other folders within Outlook. I have heard there may be a potential enhancement to incorporate Save Mail in future, but not sure of timescales. Has anyone developed something already that I could have a look at? Thanks James

Hi James,

SumanMahato — Mon, 25 Jul 2016 09:09:00 GMT

Hi James, Hope you are doing good. I have a process requirement which is similar to this. Where automation need to send a mail and save the mail in a network folder. I have created a BO for outlook operation . In save email operation the first action should be search the mail. The mail sent by automation has an unique case id in the mail subject . In save email action first task is to search the mail. So first i opened the sent mail box in outlook profile then put the unique id in search bar and press enter. the first mail in the list of result will be selected. Next action is to click on the ""save as ""icon in outlook application . When it was clicked an windows dialog box opened. Select the file type as Outlook unicode text and chose a folder. then click on save button. The mail will be saved in the network folder. I will add the BO details once the testing will be completed.

If you use the SMTP/POP3

TomBlackburn1 — Mon, 25 Jul 2016 12:35:00 GMT

If you use the SMTP/POP3 object, you can actually configure and SMTP client to send emails to the filesystem: stackoverflow.com/questions/1264672/how-to-save-mailmessage-object-to-disk-as-eml-or-msg-file

Hi James,

Anonymous — Mon, 25 Jul 2016 13:03:00 GMT

Hi James, I looked at writing some code for a client of mine that would do exactly this: Public Sub saveAttachtoDisk (itm As Outlook.MailItem) Dim objAtt As Outlook.Attachment Dim saveFolder As String saveFolder = "c:\temp For Each objAtt In itm.Attachments objAtt.SaveAsFile saveFolder & ""\" & objAtt.DisplayName Set objAtt = Nothing Next End Sub The above VB would save the attachment to a specified folder however the requirement on this one would be triggered via and Outlook Mail rule. I'm sure you could look into what would be the best solution for your circumstances but at you have the code above to at least play around with. Let me know if you have any questions and I'll do what I can to help. Thanks Jimmy

Hi all,

Anonymous — Wed, 27 Jul 2016 18:41:00 GMT

Hi all, I work with James on the same project. We are using Outlook 2010 and MAPIEx. We are currently spying Outlook to do this how a user would re: interacting with Outlook, but would prefer an object similar to the Move Mail. We'll also be asking Blue Prism to add this to their enhancements list, as our thoughts are that the Move Mail object could be used for both moving mails to other email folders OR to a network drive with a bit of tweaking to their code. We'll have a look at a couple of the suggestions to see what we can work with in the interim. Thanks

Hi Paul,

ShreyansNahar — Thu, 28 Jul 2016 12:20:00 GMT

Hi Paul, Regarding the Move mail function, I think MapieX module of Blue Prism helps in doing that when you try to Get Email from Inbox.

You can use this code in a BP

RadoslavHiko — Thu, 28 Jul 2016 12:30:00 GMT

You can use this code in a BP code stage. You will have to import Microsoft.VisualBasic and System.IO namespaces for this to work. Inputs: sEmailID (Text) - ID of the email in Outlook, sPath (Text) - where you want to save it, nFormat (Number) - format of the saved message (see the code for possible values) Outputs: [none] Code: Dim sFileName As String Dim olApp As Object Dim olNameSpace As Object Dim olEmail As Object olApp = CreateObject(""Outlook.Application"") olNameSpace = olApp.GetNamespace(""MAPI"") olEMail = olNameSpace.GetItemFromID(sEmailID) Select Case nFormat Case 0 sFileName = olEmail.Subject & "".txt"" Case 1 sFileName = olEmail.Subject & "".rtf"" Case 3, 9 sFileName = olEmail.Subject & "".msg"" Case 5 sFileName = olEmail.Subject & "".htm"" Case Else sFileName = olEmail.Subject & "".msg"" nFormat = 3 End Select For Each invalidChar As Char In IO.Path.GetInvalidFileNameChars sFileName = sFileName.Replace(invalidChar , """") Next olEmail.SaveAs(sPath & ""\ & sFileName nFormat)

Hello Radoslav,

ZdenkoŠupina — Tue, 14 Mar 2017 16:28:00 GMT

Hello Radoslav, I am trying to use the code you have provided but so far I was not successful (getting error msg: ""Exception thrown by code stage: Could not open the item. Try again""). The main issue is in my opinion in used ID. Could you probably specify what kind of ID does the use? What folder should it be in? I have tried direct ID extracted (manualy) from outlook but did not work. Thank you.

RE: Hello Radoslav,

NicolòCeccaroni — Mon, 27 Feb 2023 11:00:00 GMT

Hi,

do you find any solution to save mail? We cannot open Outlook client, so for example we want to use "email pop3 smtp" object.

Thanks, Nicolò

------------------------------
Nicolò Ceccaroni
------------------------------

RE: Hello Radoslav,

ewilson — Mon, 27 Feb 2023 13:41:00 GMT

So you just need to be able to save emails as files, but you need to do it with something other than the standard Outlook VBO?

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Hello Radoslav,

NicolòCeccaroni — Mon, 27 Feb 2023 13:51:00 GMT

Correct, I need to do it with something other than the standard Outlook VBO.

Thanks, Nicolò

------------------------------
Nicolò Ceccaroni
------------------------------

RE: Hello Radoslav,

ewilson — Mon, 27 Feb 2023 17:10:00 GMT

Ok, we've just pushed an update to the Pop3/SMTP VBO to the Digital Exchange that includes two new actions: Save Message to File and Load Message from File. These should give you what you're looking for if you're using this VBO.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Hello Radoslav,

NicolòCeccaroni — Fri, 03 Mar 2023 10:03:00 GMT

Hi Eric,

thank you very much for the object.

Kind regards,

Nicolò

------------------------------
Nicolò Ceccaroni
------------------------------

RE: Hello Radoslav,

NicolòCeccaroni — Tue, 18 Apr 2023 08:10:00 GMT

Hi Eric,

do you know if it is possible to use Email - POP3/SMTO to:

- retrieve 'EntryID' (id used on MS Outlook VBO)
- move an e-mail between several folders
- reload an .eml (the opposite of mail-saving)

Thanks,

Nicolò Ceccaroni
------------------------------

RE: Hello Radoslav,

ewilson — Tue, 18 Apr 2023 14:34:00 GMT

@Nicolò Ceccaroni

There is a Load Mail from File action that can be used to load a .eml file. As for your other questions, I believe the answer to both is no as this VBO is working directly with the mail server and not the Outlook client.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Hello Radoslav,

NicolòCeccaroni — Tue, 18 Apr 2023 15:03:00 GMT

Hi Eric,

when we use the action Load Mail from File it is not uploading the .eml on the mailbox (is this correct?):
when we use this action, we only obtain the mail data (but we don't find this mail in the inbox).

With regard to moving e-mails, is it not possible between several folders of the same mailbox?

Thanks.
Kind regards,

Nicolò Ceccaroni

------------------------------
Nicolò Ceccaroni
------------------------------

RE: Hello Radoslav,

ewilson — Tue, 18 Apr 2023 16:51:00 GMT

@Nicolò Ceccaroni

Ah, I understand. Unfortunately no, that's not possible with either POP3 or SMTP. POP3 is just for downloading a copy of an email from the mail server to the local client. SMTP will create a copy of email in the Sent folder but that requires actually sending the email.

With that said, we've started adding support for IMAP to the VBO. IMAP provides greater capabilities for mail organization, etc. So I believe we can add some of these capabilities for you, but we'll need to investigate a bit more and then, assuming it's possible, get that work scheduled.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Hello Radoslav,

NicolòCeccaroni — Wed, 19 Apr 2023 07:10:00 GMT

Hi Eric,

thanks for the update, please let us know if you add any new features.

Kind regards,

Nicolò Ceccaroni

------------------------------
Nicolò Ceccaroni
------------------------------

RE: Hello Radoslav,

NicolòCeccaroni — Wed, 13 Mar 2024 10:10:00 GMT

Hi Eirc,

do you have any updates on the possibility of uploading an .eml inside a mailbox?

Thanks,

Nicolò Ceccaroni

------------------------------
Nicolò Ceccaroni
------------------------------