MrExcel Publishing
Your One Stop for Excel Tips & Solutions

emailing worksheets only from workbook


Posted by patrick stevens on June 20, 2000 12:53 PM

I have a workbook that I need to email worksheets from. However, all the commands that I have found in excel send the entire workbook not worksheets from within the workbook. can anyone help!!!!


Posted by Ryan on June 20, 0100 6:30 PM

Hey,
I don't know about emailing a single sheet, but what you can do is code it so it copies the sheet you want to mail and move it to a new workbook and email that workbook. Should work just as well. Hope this might help, let me know.

Ryan