ChrisKad
04-17-2015, 07:18 AM
Hi :)
I'm trying to email a section of a pivot table to my boss as requested. The goal is to send to more than one person just the part of the pivot table that concerns each individual.
I am very inexperienced with VBA and I want to start learning. My boss doesn't know how to do it so I really want to help him.
I attached a file that shows what I have done so far. I really don't know where to go from there. The code creates a new excel sheet with the part of the pivot table that I selected, yet it does not email to the desired individual.
Due to reasons of confidentiality, I used fictional e-mails.
Thank you,
Chris
I'm trying to email a section of a pivot table to my boss as requested. The goal is to send to more than one person just the part of the pivot table that concerns each individual.
I am very inexperienced with VBA and I want to start learning. My boss doesn't know how to do it so I really want to help him.
I attached a file that shows what I have done so far. I really don't know where to go from there. The code creates a new excel sheet with the part of the pivot table that I selected, yet it does not email to the desired individual.
Due to reasons of confidentiality, I used fictional e-mails.
Thank you,
Chris