I hope I am putting this in the right place since this covers off on both Outlook and Exel.
Here is the problem: I have an excel file for which every hour I am emailed an update for.
What I would like to happen: when a new email arrives the master file is updated with all the new information. sometimes there is information in the new file, sometimes it is just the headers with no info.
The master file has tabs for each day but when new info is added in the name is a revision number for the day.
The name of the recieved file is always different containing date and revision info
where the 21 is the release hour in military time.
I am thinking something like the email arives, get moved into a folder, the contents get exported to the master file, the email is marked as read.
I am totally lost in outlook so I have no idea where to start. any thoughts.