I have a “For Each Email” Activity looking at the inbox and limiting to 3 emails (for testing) and set for only unread mail.
I then have an IF condition filtering current mail based on Contains string of Subject Heading.
If passed, then:
- Saves attachment
- Copies data for each row into another spreadsheet by row
- saves target xlsx file
The issue is that based on the For Each Email Activity Limit emails to first setting (set to 3), it just copies the data from the first email attachment xls 3 times into the target xlsx when it should be looking at 3 separate unread emails (and attachments) that match subject heading and writing data from each file into the target file.
At the end of the day, I’m trying to filter emails by subject and copy PO #'s from single attachment into a target xlsx for collection and final processing.
Help is appreciated!! Screenshot below