Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto-send pivot table per user
I have a pivot table which is the performance benchmarking per user. Now what
I am doing is double click on user name to drill down their performance per job, copy and plaste it on email, type the email address according to address list, and send to them one by one. Is there any built-in function or VBA/ macro to do these steps with one click? |
#2
|
|||
|
|||
Try Ron de Bruin's website, I needed to do something similar, where I had a pivot table and I needed to email each page field of a pivot table to a different email recipient. The website is as follows:- http://www.rondebruin.nl -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=375132 |
#3
|
|||
|
|||
I read the user manual, want to make sure if you select to "send sheets", do
you manually fill in recipients for every sheet? Does the add-in read the recipients from a table or what and send the right sheet to right recipients automatically? "Gary Brown" wrote: Try Ron de Bruin's website, I needed to do something similar, where I had a pivot table and I needed to email each page field of a pivot table to a different email recipient. The website is as follows:- http://www.rondebruin.nl -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=375132 |
#4
|
|||
|
|||
I used the RDBMailCDO. On this worksheet you list sheet names you want to email. I took the original Pivot Table and for the Page field I wanted to distribute I used Show Pages. This created a spreadsheet page for each value within the Pivot Table field. I then filled in the RDBMailCDO page with an X in the first column, the sheet name recipient, body text message, subject line and Filename. If a recipient were to receive more than one sheet, you just enter the sheet name on the next line below with no other detail. When you want the next recipient repeat the process above. I have put quite a few lookups in place, so that the RDBMailCDO is created automatically every month from a list of email addresses looking up against a list of values for the page field which exists in my Pivot Table. In answer to your questions, I put lookups to put the recipients names in, although you can manually fill in the recipients names. The macro then reads the recipient from the table and sends the right sheet to the right recipient. -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=375132 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet protection code conflicts with Pivot Table "auto refresh" | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Pivot Table Auto Update Data Source? | Excel Worksheet Functions | |||
ability to auto file column(s) on a pivot table | Excel Worksheet Functions |