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...