I would love to be able to automate a time consuming, tedious process that a couple of us are faced with in the office.
We receive around 130 emails 6x a year with no way to easily identify the school the email is about. There is a string within the body that looks like this - S987654.X# (the X being either a C or U and the # could be anything between 1-5). If anyone could be so kind to help me get something together that would check the incoming email body for the string and compare it to an array I would put together of all our schools and append the subject line with the school name (to come before the existing subject line). The emails would always come from 1 of 2 email addresses so it would only have to look at those addresses specifically.
Although I love tinkering with excel formulas and know some php coding, I am at a complete loss when it comes to VBA, but am excited to see something automated instead of doing the same job manually.
We receive around 130 emails 6x a year with no way to easily identify the school the email is about. There is a string within the body that looks like this - S987654.X# (the X being either a C or U and the # could be anything between 1-5). If anyone could be so kind to help me get something together that would check the incoming email body for the string and compare it to an array I would put together of all our schools and append the subject line with the school name (to come before the existing subject line). The emails would always come from 1 of 2 email addresses so it would only have to look at those addresses specifically.
Although I love tinkering with excel formulas and know some php coding, I am at a complete loss when it comes to VBA, but am excited to see something automated instead of doing the same job manually.