My company has a dedicated PC hooked up to a TV Screen. I have set up outlook on this machine with a email address to which our BI system will automatically send an Excel attachment every day.
What I would like is for some sort of VBA code in either Excel or Outlook that will check once a day at a certain time if outlook has received a mail from a specific recipient and with a specific subject (which is my automated email and hence there will be multiple instances of the "same" email - just from different dates).
When it has found this email, it should open the Excel document and switch to Excel and turn Excel to Fullscreen (Excel 2007).
The next time the macro runs, it will close the current open excel file and do the same thing again with the latest received email (which adheres to the sender/subject conditions).
Your assistance is much appreciated, as always!