Texas Longhorn
Active Member
- Joined
- Sep 30, 2003
- Messages
- 493
I have a pivot table, for example:
I also have the following code:
What I would like to do, is add to this code such that I can sort the pivot table for bettyw, and send just this data to bettyw@texas.com. Then I want to sort the pivot table on frankg, and send his data to frankg@texas.com. Etc...
Any thoughts are appreciated.
Thanks,
Bill
Email Macros.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
3 | SumofProd/Serv | |||||
4 | Manager | Total | ||||
5 | bettyw | 187,192 | ||||
6 | frankg | 489,572 | ||||
7 | markb | 233,589 | ||||
8 | GrandTotal | 910,353 | ||||
Pivot |
I also have the following code:
Code:
Sub EmailPivot()
Sheets("Pivot").Copy
ActiveWorkbook.SendMail Recipients:="billis@texas.com", Subject:="Testing"
ActiveWorkbook.Close False
End Sub
What I would like to do, is add to this code such that I can sort the pivot table for bettyw, and send just this data to bettyw@texas.com. Then I want to sort the pivot table on frankg, and send his data to frankg@texas.com. Etc...
Any thoughts are appreciated.
Thanks,
Bill