Outlook trigger UiPath Robot from VBA code | Code in Description

Cristian_Negulescu · December 16, 2021, 1:38pm

0:00 Preview of the process
0:35 Intro
0:50 The purpose of the movie
2:00 Prepare OutLook for using VBA
3:30 Simple VBA code that is just responding to the unread emails
6:20 VBA code trigger Local UiPath Robot
9:35 Present the robot from Orchestrator
10:55 Brief on all the steps that you need to do for call a job on UiPath Orchestrator
13:15 Test the main code that calls Orchestrator
15:55 Extra References that you need Add
16:45 Explain the main code
18:30 Use Postman to extract ReleaseKey and OrganizationUnitId
25:10 Conclusions
26:37 Subscribe to my channel

VBA Code:

github.com

cristinegulescu/startUiPathFromSalesforce/blob/master/StartFromOutLookVBA.txt

Private Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Private Sub Application_Startup()

    Dim olNs As Outlook.NameSpace
    Dim Inbox As Outlook.MAPIFolder
    Dim Items As Outlook.Items
    Dim Filter As String
    Dim olReply As MailItem
    
    Dim req As New MSXML2.ServerXMLHTTP60
 Dim Body As String
 Dim myUrl As String
 Dim Resp As String
 Dim Tmp As String
 Dim ProcId As String
 Dim Auth As String
 Dim param1 As String
 Dim param2 As String
 Dim param3 As String

This file has been truncated. show original

Topic		Replies	Views
Need help with UiPath robot to process emails with attachments Forum forum , question	29	138	October 8, 2024
Can server robots be triggered by an email? Or is the only way to have a script run from Outlook? Help uiautomation	3	3040	December 9, 2019
Orchestrator Event Trigger/ Outlook Mail Messages Trigger Orchestrator orchestrator , question	5	1033	November 9, 2023
Trigger robot when receiving specifik email in Outlook Robot outlook	8	2641	April 16, 2022
UiPath Outlook Configuration (Filters and Triggers) Video Tutorials mail , outlook , activities	0	847	February 26, 2021

Outlook trigger UiPath Robot from VBA code | Code in Description

Related topics