B BWH1952 Jun 29, 2008 #1 i am attempting to e-mail one page of a workbook and can not figure out how. i do not wish to attatch the complete workbook.
i am attempting to e-mail one page of a workbook and can not figure out how. i do not wish to attatch the complete workbook.
G Gord Dibben Jun 29, 2008 #2 If you mean one worksheet and not one "page", you could copy that worksheet to a new workbook and send that as an attachment. If you mean one "page" from a worksheet, select and copy then paste into the body of your email message. Or File>Send to>mail recipient>send current sheet as message body. For all Excel email questions get answers at Ron de Bruin's site. Note the SendMail add-in available as well as the code. http://www.rondebruin.nl/sendmail.htm Gord Dibben MS Excel MVP
If you mean one worksheet and not one "page", you could copy that worksheet to a new workbook and send that as an attachment. If you mean one "page" from a worksheet, select and copy then paste into the body of your email message. Or File>Send to>mail recipient>send current sheet as message body. For all Excel email questions get answers at Ron de Bruin's site. Note the SendMail add-in available as well as the code. http://www.rondebruin.nl/sendmail.htm Gord Dibben MS Excel MVP
