Digital Exchange

 View Only
last person joined: yesterday 

This community is a place to discuss Blue Prism DX assets and development.

Expand all | Collapse all

MS Outlook Get Received Items Basic

  • 1.  MS Outlook Get Received Items Basic

    Posted 02-22-2020 13:44
    Hi,

    I'm trying to run a 'Get Received Items Basic' action with the MS Outlook VBO.  But this error triggers every time I run it - Internal : Could not execute code stage because exception thrown by code stage: Object variable or With block variable not set.

    I'm new to Blue Prism so I don't know if I'm missing a step or anything.  Do I need to run a step before running the Get Received Items command?  Eventually I'm planning on running some filtering but at the moment I'm just trying to test if Blue Prism can connect to my Outlook.

    ------------------------------
    Quinn Anderson
    ------------------------------


  • 2.  RE: MS Outlook Get Received Items Basic

    Posted 02-22-2020 21:25
    What inputs are you using? If you are giving it any inputs, try running it with no inputs at all. It may take a bit to run if you have a lot of emails but it should work with no inputs.

    Also, open the MS Outlook Email VBO, and see if there are any Errors at the top left of Object Studio in the Business Object Validation popup. Or you may just see (0) Errors which means it's fine.

    I'll watch for your response. I'm not personally sure how to guess what the issue is without being able to reproduce it. So these two things above would be a good start.

    ------------------------------
    Dave Morris
    3Ci @ Southern Company
    Atlanta, GA
    ------------------------------



  • 3.  RE: MS Outlook Get Received Items Basic

    Posted 02-23-2020 13:13
    I tried running it without any inputs and got the same issue.  The VBO itself is reporting 0 errors. 

    I should also note the only action that I currently have in the studio is 'Get Received Items Basic'


    All the best



    ____________________________________

    Quinn R. Anderson

    Master of Advanced Analytics | Consultant | Data Scientist

    Aspirent Consulting, LLC


    6600 Peachtree Dunwoody Road NE
    400 Embassy Row, Suite 260
    Atlanta, GA 30328
    C:  (303) 324-7645

    L: www.linkedin.com/in/quinn-r-anderson-0aa3a340








  • 4.  RE: MS Outlook Get Received Items Basic

    Posted 02-23-2020 17:00
    And you have the Microsoft Interop dll in your Blue Prism Automate folder?

    It should be here: C:\Program Files\Blue Prism Limited\Blue Prism Automate\Microsoft.Office.Interop.Outlook.dll

    Normally it will give a different error if that is missing. It'd be something like 'the object has compile errors' or similar wording. But this dll being missing is one of the primary reasons for the object not working for people.

    Also, have you attempted any of the other actions (other than Get Received Items)?

    And last question for now... Do you have access to another machine where you can install Blue Prism and attempt this just to see if we can get it working on any machine you have access to?

    ------------------------------
    Dave Morris
    3Ci @ Southern Company
    Atlanta, GA
    ------------------------------



  • 5.  RE: MS Outlook Get Received Items Basic

    Posted 02-23-2020 18:15
    I think I figured it out actually!  I do have the dll.  The problem seems to be that the Basic action requires something to filter off of.  I'd been trying to grab all my emails to make sure that the connection itself was working, but that seems to trigger this error.  When I insert a criteria for the action it runs correctly.

    This has brought up a separate issue however, in that it seems like the "Sender Email" field doesn't grab anything.

    ------------------------------
    Quinn Anderson
    ------------------------------



  • 6.  RE: MS Outlook Get Received Items Basic

    Posted 02-23-2020 18:21
    Hmm... that's weird. It shouldn't require any inputs. I just tested it again and it works for me. When you run it with no inputs, does it throw an error immediately or does it throw an error after a delay?

    Another question. What kind of Account is set up in Outlook? Is it an Office 365 email account or something else?

    ------------------------------
    Dave Morris
    3Ci @ Southern Company
    Atlanta, GA
    ------------------------------



  • 7.  RE: MS Outlook Get Received Items Basic

    Posted 02-23-2020 18:24

    There is a delay and then it throws the error.  The email is office 365.






  • 8.  RE: MS Outlook Get Received Items Basic

    Posted 02-25-2020 12:02
    Have you tried this on another machine?

    ------------------------------
    Dave Morris
    3Ci @ Southern Company
    Atlanta, GA
    ------------------------------



  • 9.  RE: MS Outlook Get Received Items Basic

    Posted 11-09-2020 13:08
    Thanks for this conversation. I removed all of the inputs and was able to get the received items. However, is it possible to get items from only one email? All emails from X@x.com for example. When I add the "sender name" or "sender email". I do not get an error I get nothing at all in the collection.

    ------------------------------
    Barry Bell
    RPA Manager
    DHGLLP
    America/New_York
    ------------------------------



  • 10.  RE: MS Outlook Get Received Items Basic

    Posted 11-09-2020 13:48
    Check what value is in those fields when you do 'receive' with no inputs first. Like, first run it to get a collection of the emails and then look in the results to see the exact value it shows for the email you want. Sometimes the sender name and other fields like it can be unreliable or in a different format than you'd expect. There also could sometimes be apostrophes.

    ------------------------------
    Dave Morris
    Cano Ai
    Atlanta, GA
    ------------------------------



  • 11.  RE: MS Outlook Get Received Items Basic

    Posted 11-09-2020 14:07
    I did what you suggest with no joy, there was a difference it the way I was imputing the email "x.x@ABC.com" vs "X.X@ABC.com" What I did get to work before you replied was using the Subfolder "Subfolder" and I just tried using the name of sender instead of email and that worked.

    My next question is: using the Save As VBO for outlook.. You have to have an "Entry ID" (which I took from the collection) and had a file path. Below is the error I am getting. Any thoughts.
    I used quotes around the file path.
    I used the "Entry ID" from the collection(Text) and gave the file a name to use.

    What am I missing here? Thanks





    ------------------------------
    Barry Bell
    RPA Manager
    DHGLLP
    America/New_York
    ------------------------------



  • 12.  RE: MS Outlook Get Received Items Basic

    Posted 11-09-2020 14:18
    I figured out my other issue. I was putting quotes on my file path and had to add a backslash.  Rookie mistakes.

    Thanks

    ------------------------------
    Barry Bell
    RPA Manager
    DHGLLP
    America/New_York
    ------------------------------



  • 13.  RE: MS Outlook Get Received Items Basic

    Posted 11-09-2020 14:40
    No worries. Gotta love that helpful error: "The operation failed." Hahahahaha!

    ------------------------------
    Dave Morris
    Cano Ai
    Atlanta, GA
    ------------------------------



Welcome to the Blue Prism Digital Exchange Community!

The Blue Prism Digital Exchange is a "shop window" for new and emerging technologies—a platform that puts powerful RPA and AI capabilities into the hands of business leaders. Users can find and apply pre-built AI capabilities, in the form of downloadable integrations and Visual Business Objects (VBOs), to automated processes. These assets connect and integrate Digital Workers, existing systems and processes to Blue Prism's technology partners, creating a solid foundation of AI-enabled Intelligent Automation that's scalable and sustainable.

Blue Prism Digital ExchangeDX Asset IdeasContact DX Support

FAQs

The Blue Prism Digital Exchange (DX) is an online marketplace where businesses can instantly access, apply and share pre-built AI, cognitive and advanced RPA technologies from best-in-class providers. These assets easily connect to existing digital workers, systems and processes to enhance automation capabilities.
The Digital Exchange is free to all users. Most of the content on the DX is free to download but there are some submissions that do have a cost associated. The submissions with a cost are advertised on the asset card and profile. No unwanted costs will be applied to any users.
You can visit and browse the Digital Exchange here. If you would like to consume or download any material it is necessary to create an account on the Blue Prism Portal first.
Everyone can access the Digital Exchange and consume the assets on it. If you would like to contribute to the marketplace it is necessary that you create an account and sign up as a partner.