This list will create a new workbook containing the 3 sheets that we have included within the Array() parameter. Sheets(Array("Cover", "Interval Data", "rawData")).Copy I will be discussing only the key elements of the code here. We have then used the COUNTIFS and SUMIFS function to create the data view in the Interval Data sheet. If you need to setup your report into 15 minutes interval then replace 1/48 with 1/96. The time has been calculated by converting the actual time of the call into the relevant 30 minute interval. We have then updated the “rawData” sheet with 2 new columns having the Date and Time.ĭate has been calculated in the rawData sheets using the Date Function. We have assumed the data used to create the report is already available in the sheet called “rawData”.
If you have a different version of Outlook installed on your system, you need to point to the correct library installed. Please note the Outlook library will be available depending on the version of Microsoft Outlook installed on your system, in the example workbook the reference is towards version 14 as available with Outlook 2010. On our VBA project we would need to add references to the below Sending mail using Microsoft Outlook, primary target is corporate people who are using Outlook as their mail program. Email sheet to contain the list of people who are going to receive the report.ģ. Code will automatically create necessary folders to save the output file.Ģ. We will define the recipient list in a separate sheet.
We want to update this template using VBA code to create a static version and email it to a list of people. We have an excel based reporting template for the Customer Service Dashboard.
In this article we well learn how to use VBA and Microsoft Outlook to send emails with your reports as attachment.
This is a guest post by Vijay, our in-house VBA Expert.