9 Replies Latest reply: Oct 22, 2012 2:03 PM by hsharmas RSS

    Macro: List box Value Selection and copying report to excel then mailing

      Hi Guys,

       

      I am trying to create a macro which selects a particular value of a field, copy the pivot chart to excel and mail it to particular recepients on a Tuesday every week.

       

      I found success in copying the pivot chart to excel and mailing it by creating a button. Inside, in Actions tab selecting External and Run macro and editing the macro.

       

      What i am unable to do is:

      • How to include conditions that select value of a field, in turn the chart modifies and then mailing it.
      • How to automate the process, so on a Tuesday when the data reloads, last week's summary is mailed to particular persons.