I'm sure there a a number of ways to do this, but one way is to copy the
sheet to a new file, break link then attach it to an email. To do this,
right click on the sheet tab then select <Move or Copy. Check the "Create a
Copy" box then in the "To Book" dropdown select "New Book" then hit "OK".
That will create a new workbook with only that sheet in it. In the new
workbook you probably have some formulas refering back to the original
workbook that are undesireable. To fix that, from the menu hit <Edit<Links
then <Break Links <Break Links. That will convert all of the formulas
refering to the original workbook to simple values.

Hope that works for you.

"rj shoe" wrote:

I have a worksheet that has been subtotalled with every page containing
individualized information per person (a list of their items sold for the
month and the total) and would print out exactly as I want but I don't want
to physically print it out. I want to be able to email each person's
individualized page to them.

If I could save each page to a file per person I could attach it and then
email but I don't know how to save each page separately. Can this be done?