LinkBack URL
About LinkBacks
Say I have 10 sheets in an Excel workbook file. Is it possible to isolate a single sheet and attach it to an e-mail?
Say I have 10 sheets in an Excel workbook file. Is it possible to isolate a single sheet and attach it to an e-mail?
You cannot save it as an email but if you select the sheet that you want to isolate then save as PDF(Excel 2007+) or CSV. It will save the selected sheet only. Then you can attach it to an outgoing email.
you could also use a macro to copy the sheets into their own workbooks, and send those as attachments.
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
Is it easy to convert the PDF back to an Excel sheet?Originally Posted by Dennis7849
hi,
just see if it helps you
Please Login or Register to view this content.Please Login or Register to view this content.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
Ron de Bruin's page: http://www.rondebruin.nl/sendmail.htm is an essential guide to emailing options in Excel - variety of examples.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks