Heres my situation:
Every hour, I am sent an email containing a table that looks like this.
I basically need a way to auto-check an email folder, locate the most recent file (each file is the same table just with updated metrics)
and paste all that data into my spreadsheet with the click of a (most likely activex) button. Is this something that's possible? I know outlook and excel have certain functions that can interact with each other, but I don't know if this is at all possible. Any help is extremely appreciated!
Every hour, I am sent an email containing a table that looks like this.
I basically need a way to auto-check an email folder, locate the most recent file (each file is the same table just with updated metrics)
and paste all that data into my spreadsheet with the click of a (most likely activex) button. Is this something that's possible? I know outlook and excel have certain functions that can interact with each other, but I don't know if this is at all possible. Any help is extremely appreciated!