topic Hi Ami, Where would you… in Product Forum

Outlook VBO on Multiple Email Boxes

Liam_Heiniger — Fri, 05 Oct 2018 10:50:00 GMT

I'm attempting to use the Outlook VBO with release 6.3 to pull all the sent emails from the various group emails on my Outlook but I an only get the sent emails from my default email a none of group emails. Does the out Outlook VBO allow me to pull sent emails from a group email I'm a part of, any tips, hints or suggestions about how to go about solving this issues?

I haven't used the 6.3 VBO,…

AmiBarrett — Wed, 10 Oct 2018 01:05:00 GMT

I haven't used the 6.3 VBO, but I did wind up writing my own object to interface with Outlook via MAPI after getting fed up with the instability of MAPIex. If you're willing/able to write your own as well, there is a connection option to define use of a shared mailbox. Alternatively, you might be able to set it up as a separate Outlook profile. If the Outlook VBO in current releases is similar to the prior mail handlers, profile should be an optional field.

Hi Ambarrett, The MAPIex is…

Liam_Heiniger — Wed, 10 Oct 2018 05:51:00 GMT

Hi Ambarrett, The MAPIex is able to deal with multiple mailboxes with multiple profiles however, it doesn't have the ability to search by subject. Do you think it would be easy to build in subject or filter search functionality in the MAPIex object? Thanks for getting back to me, looking forward to hearing from you.

As far as I know, the…

AmiBarrett — Wed, 10 Oct 2018 09:37:00 GMT

As far as I know, the Outlook automation library doesn't allow for that (directly), as they're all looked up by message ID instead. What you could do, is code it to loop through a box until it finds a specified subject. It won't mimic the search function you actually get in Outlook, but it'll get the job done. But again, this would involve a custom mail handler and not MAPIex. If you are dead-on intent to stick with MAPIex, you'll need to keep calling 'Get Next Mail' and check the subject that way. But be aware that checking this way is significantly slower than it would be in a custom code stage. (Though if you were to instead write this as an external powershell script file, it would be slower than looping through MAPIex results.)

Thanks for the information…

Liam_Heiniger — Fri, 12 Oct 2018 04:22:00 GMT

Thanks for the information. I'm actually pretty keen on using the new MS Outlook EMail VBO as I like to use the Save Email As File Action along with the Get Sent Items and Get Receive Items actions. Thanks for the help, if you do think of to have the new MS Outlook Email VBO to interact with multiple group emails please let me know.

I just imported it into my…

AmiBarrett — Sat, 13 Oct 2018 00:22:00 GMT

I just imported it into my instance of BP5x. Looks like it should work, if you can supply the correct folder ID. It may just take some trial and error to figure out the folder's ID number. There are ways of doing this with code, but it may be quicker to just iterate through a list of numbers and see which one happens to be the correct one.

Hi Liam, I am facing the…

Anna_BlytheHewi — Fri, 16 Nov 2018 22:55:00 GMT

Hi Liam, I am facing the same issue. Have you figured out a workaround yet?

I've had time to dissect…

AmiBarrett — Sat, 17 Nov 2018 00:27:00 GMT

I've had time to dissect this VBO a bit more, and was able to rewrite my own handler based on some of the streamlining in this one. By default, it will pull for all attached inboxes on the default profile. You could probably apply a filter string to set the recipient address. Alternatively, you can make modifications to the actions to account for a profile and/or shared inbox.

Profile and sharedEmail should be of type Text. Place this right after the namespace declaration and modify the code/start stage inputs accordingly. sharedEmail should be the address of the attached inbox, whereas Profile should match the label of your Outlook profile if it's intended for anything other than the default.

Dim olSharedRecip as object
if Profile <> "" then
    _nameSpace.Logon(Profile, , True, True)
end if

if sharedEmail <> Nothing then
	olSharedRecip = _nameSpace.CreateRecipient(sharedEmail)
	folder = _nameSpace.GetSharedDefaultFolder(olSharedRecip, Outlook_Folder_ID)
end if

Hi Ami, Where would you…

JamesSmith1 — Mon, 19 Nov 2018 10:05:00 GMT

Hi Ami, Where would you place that code stage within the ""Get Received Items (Basic)"" MS Outlook Email VBO? I ask as I want to be able place restrictions on the emails being aggregated.

All of the Get Items actions…

AmiBarrett — Mon, 19 Nov 2018 21:35:00 GMT

All of the Get Items actions just call the ""Internal_Get Items"" page, which is intentionally unpublished. You'll need to modify the code stage on that page, then modify the page reference on your Get Sent Items and Get Received Items actions. You'll also need to add those two fields to the start stages on all of these pages, including ""Internal_Get Items"". Assuming you update the page reference with these new variables (defaulting to blank is fine), that should be all you need to do.

Was anyone able to implement…

pranavred — Thu, 03 Jan 2019 19:02:00 GMT

Was anyone able to implement what amibarrett suggested? I'm a bit lost and would love some more guidance.

Which part do you need help…

AmiBarrett — Mon, 07 Jan 2019 23:12:00 GMT

Which part do you need help on? I'm happy to elaborate if needed.

Thanks amibarrett. I'm able…

pranavred — Thu, 10 Jan 2019 19:37:00 GMT

Thanks amibarrett. I'm able to get mails from different profiles after a bit of playing with the code. Has anyone tried moving emails to subfolders in non-default profiles?

Do you mean within the same…

AmiBarrett — Fri, 11 Jan 2019 20:35:00 GMT

Do you mean within the same profile, or from one profile to another? If the former, you could make similar modifications to the ""Move Email to Inbox Sub Folder"" action. If the latter, I can see two options. The first is to save an e-mail as a file, then try to re-import to a new profile. The second would be to add the address of the second profile as a shared mailbox, rather than a second profile.

Hi Ami, Are you able to read…

NilanshuSoni — Mon, 14 Jan 2019 18:25:00 GMT

Hi Ami, Are you able to read the emails from different mailboxes through any code? If yes, can you please share that code.

Yes - the required code has…

AmiBarrett — Mon, 14 Jan 2019 20:30:00 GMT

Yes - the required code has already been provided in a previous post in this thread.

Thanks a lot for the…

AndreaFrauchige — Tue, 26 Feb 2019 20:52:00 GMT

Thanks a lot for the solution - was able to amend the VBO. thumbs up!

Hi, Are you guys able to…

AkshayBassi1 — Fri, 01 Mar 2019 10:19:00 GMT

Hi, Are you guys able to share the changes you made to be able to retrieve emails from multiple mailboxes/a different mailbox? Thanks

You could always change…

AndreasMontanus — Tue, 26 Mar 2019 13:22:00 GMT

You could always change profiles using the this little registry hack before reading the mailbox. Just set up the different mailboxes with their corresponding profiles and change to the profile using ""profileName"". Success = false; try { RegistryKey myKey = Registry.CurrentUser.OpenSubKey(""Software\\Microsoft\\Office\\16.0\\Outlook"", true); if(myKey != null) { myKey.SetValue(""DefaultProfile"", profileName, RegistryValueKind.String); myKey.Close(); Success = true; } } catch { Success = false; } - MSN

@amibarrett Accessing the…

david.l.morris — Tue, 26 Mar 2019 16:39:00 GMT

@amibarrett Accessing the shared mailbox worked like a charm. Thanks!