Please reply all to this email with the most current status of this project and update the tracking spreadsheet here with the same status: url. Please be advised that your project for Company22 with an Effective Billing Date of 4/1/16 for Product R8T is going to reach a deferred revenue state in 1 day(s). Subject: Project PR-3K4K587 for Company22 The email would look something like this: To create the master pivot table from these different worksheets, we need to enter into the Pivot table, and Pivot Chart Wizard this function was disabled in earlier MS Office versions, but we can access the same by the short cut keys Alt + D + P. A sample template is below.īelow is an example of the pivot table i would like to use to generate the email. In the example below 11 emails would need to be generated to various people. The goal is to use a button to automatically generate a notification email to the 'Owner' and CC the 'Project Owner Manager' where the Subject and Body of the email would incorporate data from the Pivot Table. Windows macOS Web Select any cell within the PivotTable, then go to Pivot Table Analyze > Filter > Insert Slicer. I need help to generate an email using various fields of a pivot table as some of the source information for the email subject and body.īackground: Each week I create this table from a new set of data. Tip: Beginning in Excel 2016, you can multi-select slicers by clicking the button on the label as shown above. I have received some excellent assistance here in the past and I am hopeful this will yield the same result. I am a novice when it comes to writing Macros or VBA for Excel.
