Achieving an Email Workflow with Outlook 365: Step-by-Step Guide
·
I was wondering if anyone thought this specific workflow was achievable:
- 1.
Search an Outlook 365 mailbox between two dates to find emails from a specific sender.
- 2.
Search within those search email results for a particular section of a formatted email newsletter.
- 3.
Parse companies mentioned in the section text, as well as each short description provided for each.
- 4.
Extract each company identified and the related short description to a new spreadsheet for each email.
- 5.
Search for the company URL using the company name and short description.
- 6.
Write the URL to a new column in the spreadsheet.