I’m automating e-mail processing and I’ve come across a couple things I can’t seem to find the solution to:
I want to retrieve information from the e-mail subject (a three digit code that determines which clerk is responsible for the processing of this email) and compare it to an excel table, where the code is assigned to the specific clerk.
–> Unfortunately I don’t know how to extract the subject data.
–> Concerning the comparison, should I use the “matches” or “compare” transaction?
Then I want to forward the e-mail to the respective clerk.
–> Would it work to filter the table and copy the text in the adjacent column?