- We have a general mailbox (help@company.com) that 10+employees work out of to send and reply to messages.
- The signature is identical for each employee, except we have incorporated an invisible, unique keyword to each employees signature.
| Employee Name | New Email Key | Reply Email Key |
| Employee1 | crtttech-0001 | crtttech-1001 |
| Employee2 | crtttech-0002 | crtttech-1002 |
| Employee3 | crtttech-0003 | crtttech-1003 |
Goal:
- If someone sends an email from our shared mailbox scan the body of the email and find the first match in the table above. As long as it stops looking after the first match, it should not overlap with other employees, replying on the same thread.
- If no match is found, do nothing
- If a match is found, write the date/time and matching keyword to an existing excel sheet (emailtracker.xlsx)
| Date/Time | Keyword |
| 1/1/2022 14:30 | crtttech-0001 |
| 1/2/2022 14:30 | crtttech-1001 |
| 1/3/2022 14:30 | crtttech-0002 |
| 1/3/2022 16:30 | crtttech-1003 |
- My hope is to be able to create a table that shows the employees email work over a period of time
| Employee | New Emails | Replies |
Employee1 | 1 | 1 |
| Employee2 | 1 | 0 |
| Employee3 | 0 | 1 |
| | | |
Any ideas on how to do this? I am also open to alternative approaches if there is a better way to accomplish the above.
Thanks in advance for any guidance.
