title: Use of VBA to open Excel attachment received via Outlook email, create table report (with Excel Macro) and distribute report via email internally
body: <p>I receive a specific email in Outlook (same sender and email subject) with an excel attachment(.xlsx) 3 times per week. Certain data from this spreadsheet are needed to create a table report (on a new worksheet) that is then distributed internally as the body of an Outlook email.</p>
  <p>Although I am totally new to VBA, thanks to numerous posts and videos found online, I managed to complete the excel macro that compiles the table report and copies it to the body of a newly created email in outlook. However, I still have to do the following actions each time the respective email comes to my inbox:</p>
  <ol>
  <li>Download Excel file .xlsx to a specified folder</li>
  <li>Open Excel file .xlsx</li>
  <li>Save it as .xlsm to a specified folder</li>
  <li>Run my Macro (i.e. internal report distribution)</li>
  <li>Close Excel file</li>
  <li>Delete both excel files (.xlsx &amp; .xlsm)</li>
  </ol>
  <p>I was wondering if the above steps could also be programmed with a vba script either in Outlook or Excel so as to become effective each time this specific email is received in my inbox.</p>
  <p>Thanks in advance for your kind feedback and support.</p>