Kon: You are the guru on the mountain! I cant say enough how much I appreciate this! The code so far works well, I thank you! I have a few questions: How should I approach setting up the body of the email with either the pivot table itself, or a block of text that is the warnings array, with warning...

Kon: Thank you so much! I have been stuck on this longer then I care to admit. The VBA output of what I need to do to the chart still is: Sub Macro1() ' ' Macro1 Macro ' ' ActiveChart.PivotLayout.PivotTable.PivotFields("Time").Orientation = xlHidden With ActiveChart.PivotLayout.PivotTable.PivotField...

I wrote the code below to parse a system generated email, create a chart, and email the chart and formatted data to recipient, Got it to the point(sloppy im sure) that the chart gets created, the only things im missing is adding "warning" to the legend field in the pivot table, and changing Axis(cat...

I am trying to create a pivot table, and then a pivot chart from ahk for embedding into an email. I am a total noob, so please forgive my code quality. I am having trouble getting my pivot table set up right, and cannot get a chart to appear for the life of me. I have included references to what pos...