Integrating IBM RPA with Outlook desktop application

Ensuring Outlook is open

As Outlook must be open so IBM RPA can establish the connection, let's make sure that it is. You can use IBM RPA's recorder** tool to map Outlook application's menu and make it even easier to build your script.

1. With your Outlook desktop application opened, click the Start Recorder button in IBM RPA Studio's ribbon. After loading the drivers, the recorder's menu bar appears at the top of the screen.
2. Place your mouse cursor on the Outlook panel and hold the Ctrl + Shift key on your keyboard until the panel is highlighted in green.
3. On the recorder bar, click Window > Wait for window to appear.
4. The Wait for Window to appear (waitWindow) opens. Notice how some parameters are already filled.
   1. On Success, enter windowStatus and click Save.
5. Click Home > New Routine.
6. On Name, enter openOutlook and click Save.
7. Drag the Launch and Attach Window (launchWindow)command to your script.
   1. On Executable, click the File selection helper button and search for the OUTLOOK.EXE executable. The file path can look like: C:\Program Files\Microsoft Office\root\Office16\OUTLOOK.EXE.
   2. Click Save.
8. In the script's main routine, drag the Run Subroutine if (gosubIf) command.
   1. On Name, select openOutlook.
   2. On Left Operand, enter ${windowStatus}.
   3. On Operator, select Is true.
   4. Enable Negate.

Connecting to Outlook Server

1. Drag the Connect to Outlook Server (outlookConnect) command to your script.
   1. On Email, enter the email that is connected to the Outlook application.
   2. On Connection, enter outlookConnection and click Save.

Filtering emails

1. Create a new variable called keyWords of type List<Text>, add words that you want to filter for. In this tutorial, the word is testing.
2. Drag the Apply Search Filters (emailApplySearchFilters) command to your script.
   1. On Connection, enter ${outlookConnection}.
   2. Enable Search all Folders.
   3. On Inclusive Words in the Subject, enter ${keyWords} and click Save.

Reading and logging the contents of filtered emails

1. Create a new variable called emailMessageInstance of type Email Message.
2. Drag the For Each (forEach) command to your script.
   1. On Collection, enter ${outlookConnection}.
   2. On Variable, enter ${emailMessageInstance}.
3. 1. Drag the Read Email (emailRead) command between the For Each construct.
   2. On Message, enter ${emailMessageInstance}.
   3. On Subject, enter emailMessageSubject.
   4. On Email Body, enter emailMessageBody.
4. Drag the Log Message (logMessage)command below the Read Email command.
   • On Message, use the following text:

Subject: ${emailMessageSubject}

Body: ${emailMessageBody}

------

You must have the following script as a result:

You can copy the script syntax on the Results section.

Run the script. On IBM RPA Studio's Output panel, you should see the subject and body of each filtered email message from your email account.