S
Spoonerstreet
I have a set of Workbooks, each with multiple worksheets.
Each worksheet represents the tracking of a particular person. I
would like to set up a macro that will send THAT worksheet to THAT
person.
For example, I have a workbook with the tabs "Steve", "Mary", and
"John.
I would like to click one button and have it send an email to Steve
with his sheet, Mary gets a separate email with just her sheet, and
John gets one as well.
How can I put their email address into the page and have Excel send
the email out with the sheet in the body of the page so they can
receive updates to their pages without printing?
Thanks!
Excel 2003, btw.
Each worksheet represents the tracking of a particular person. I
would like to set up a macro that will send THAT worksheet to THAT
person.
For example, I have a workbook with the tabs "Steve", "Mary", and
"John.
I would like to click one button and have it send an email to Steve
with his sheet, Mary gets a separate email with just her sheet, and
John gets one as well.
How can I put their email address into the page and have Excel send
the email out with the sheet in the body of the page so they can
receive updates to their pages without printing?
Thanks!
Excel 2003, btw.