I have a pivot table run that uses "show pages" and produces about 100
worksheets.

Need to email some, but not all worksheets to different addresses. ie.
worksheet 1 goes to A, worksheet 4 goes to B, etc. I would like the emailed
versions to be in the same format as the original file, but without formulas
showing.

Appreciate any guidance ...