Automated Excel Export and Email Macro

    The intended purpose is to automate the exporting of an object to a predefined file location in Excel format unless the chart renders no data in which it would export a confirmation file in .txt format. For the Excel export portion, there exists the ability to iterate over a field's values within the dashboard for the exported file. Then, It would take the corresponding file and attach it to an email - sent via SMTP to a predefined recipient list. The sequence is cascaded through a series of files - primarily in order to trigger the execution without interfering with the existing (production) dashboard. This includes utilizing an additional qvw in order to start the .bat file which enables the scheduling within the QMC.

     

    I've attached a .zip folder containing all the required documents to view the set up as intended. It can easily be adapted or taken apart to meet a variety of needs.