Outlook
Description
The Outlook activity allows workflows to retrieve emails from a Microsoft Outlook account based on specific criteria such as received date range, folder name, subject filtering, and whether to include attachments. It provides a flexible way to automate inbox monitoring, content extraction, and attachment handling directly within workflows.
Use this activity to:
- Automatically download and process emails
- Filter emails by subject using regular expressions
- Collect attachments for downstream processing
- Extract metadata (sender, recipient, time) for analysis or forwarding
Use case: A finance team can use this activity to extract invoices sent to a shared Outlook folder, filter messages by subject (e.g., “Invoice”), and pass the attachments to a document parser for automated data extraction.
Input
Not Applicable
Output
| Output Type | Format | Description |
|---|---|---|
| Data | Table | A list of email records with details like subject, sender, received date, and attachments. |
Configuration Fields
| Field Name | Description |
|---|---|
| Connection | Select or configure an Outlook connection. This is required to authenticate access to the Outlook mailbox via OAuth. |
| From Received Date | Specify the start of the date range for email retrieval. Only emails received after this date will be considered. |
| To Received Date | Specify the end of the date range. Only emails received on or before this date will be fetched. |
| Folder Name | Name of the Outlook folder (e.g., “Inbox”, “Finance”, “Archive”) from which emails should be retrieved. |
| Download Attachment | Enable this option to automatically download attachments associated with each email. Stored as a list of file paths or blob references in output. |
| Subject Regex | Provide a regular expression pattern to filter emails based on the subject line. Only emails with subject lines matching the pattern will be included. |
Sample Input
Not Applicable
Sample Configuration
| Field | Value |
|---|---|
| Connection | Outlook Shared Mailbox |
| From Received Date | 2024-06-01 |
| To Received Date | 2024-06-30 |
| Folder Name | Invoices |
| Download Attachment | Enabled |
| Subject Regex | (?i)invoice.*\.pdf |
Sample Output
| MessageId | ReceivedDate | From | To | Subject | Body | Attachment |
|---|---|---|---|---|---|---|
| MSG001 | 2024-06-10T09:45:00Z | [email protected] | [email protected] | Invoice #12345 | …HTML/text… | invoice12345.pdf |
| MSG002 | 2024-06-12T14:22:00Z | [email protected] | [email protected] | Invoice June Report | …HTML/text… | june_invoice_summary.pdf |