E-mail Part of excel sheet

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

How do you select and e-mail part of a work sheet, each
time i try i get the whole sheets as part of the e-mail
 
How do you select and e-mail part of a work sheet, each
time i try i get the whole sheets as part of the e-mail
Click to expand...

I don't think it can readily be done programmatically. However, if you
use an e-mail client which supports messages in HTML (I use Outlook), you
can copy/paste a part of your worksheet into the body of the message.

To create an attachment in VBA, you would have to construct a temporary
workbook with only the content you want, and e-mal that.
 
Back
Top