In '07, start with a left-click in the pivot table.
From here, please excuse my lack of '07 nomenclature... but you should see
that 'Pivot Table' and 'Options' are highlighted, and there are tabs on the
ribbon (?) for Pivot Table, Active Field, Group, etc. On the first tab,
select Options, then Show Report Filter Pges.

"jenn" wrote:

right click on the pivot table
goto pivot table options.
tabs are layout/format, totals&filters, display, printing, data

I don't see a 'show report filter pages'

I have previously changed my pivot table display to 'classic pivot table
layout'
could this be why I don't see the option ?

"bpeltzer" wrote:

Have you tried to 'show pages'? It can create a separate sheet for each
recipient in no time flat. It sounds like you might be using Office '07, in
which case you would click in the pivot table, then under Pivot Table Options
select Show Report Filter Pages. If you're using another version,
right-click in the pivot table and select Show Pivot Table Toolbar. Then
click the drop-down next to 'Pivot Table' and choose 'Show Pages.'


"jenn" wrote:

Each tuesday I run a report that shows me a list of items that a person needs
to work on. I have these in a worksheet and have been putting the list into a
pivot table... putting the person responsible in the report filter and
copying the contents of the page for the e-mail I send for the person that I
have selected in the report filter. make sense?

I have 17 people that I do this for each week. There may be no items and
there may be 15 items for each person.

How else (faster) could I break my list into each responsible person's items
and e-mail them... I'm open to suggestions...