Hi All,

We're currently working to have a number of personal records stored digitally, rather than as a paper record. One of the processes for this will involve software reading the heading in emails and then sending it on to a folder in our record keeping system. The problem is that the system isn't clever enough to know that some records refer to multiple people and so need to be sent to multiple folders.

Right now our solution is to manually forward the email multiple times, and if we have 50 employees in one record, we need to forward the email 50 times, adjusting the subject line each time (so each includes the individual employee ID).

Is there a way to automate this? I had thought something along the lines of placing all the relevant employee numbers in an excel spreadsheet, then run a script that will send the email 50 times to a dedicated inbox with a different subject line for each one. The subject line will have three sections look something like this:

Employee ID - Position Change - 13/05/2019,
or this
Employee ID - Tax Update - 15/07/2020

and so the Employee ID would change, but the rest of the subject heading would remain the same.


Anyone have any thoughts on a way to make this work?