I have a couple of VBA macros that if married properly, could do what I'm trying to accomplish. I just don't know how to marry them. The objective is to parse the subject line of messages in a particular folder and export only the computer name into the Excel spreadsheet. The subject line is in the following format:
From Server1 This file has been found on COMPUTERXYZ
I need COMPUTERXYZ from each email written to the spreadsheet. I've attached the 2 VBA scripts.