I get a lot of Data Loss emails 100-200 a day. I don't have the time to read every one of them everyday. (It seems like a lot, but we are tracking everything anybody sends outside of the network that have keywords in the email, and I get them all for only one site right now)
So I set it up that when I receive an email it is automatically added to the access table DLP_Emails. This works great copies all the details I need.
However, the message body can be a bit lengthy.
Is there a way in VBA to look at that field, go nine lines down and look to the right 19 characters and copy everything after that (to the right) to it's own field?.