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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

forwarding xcel sheets 2
e-mailing a single Sheet 1
Bulk delete e-mails in Outlook 2
Distributing Excel reports 4
E-mailing worksheet from Excel -- only one tab 1
how to eliminate E-mail "To" & "CC" boxes at top of Excel Sheet 10
e-mail/copy 1 shhet 1
How do I e-mail 1 page of a multi page workbook 3

Back
Top