Emailing a worsheet from a button in Excel

  • Thread starter Thread starter john
  • Start date Start date
J

john

I am trying to email a worksheet by simply pressing a button which
will emulate the Send facilty in Excel (2002). Creating button and
linking it to the code is no problem but I can't find any code to do
it. The worksheet would then be displayed on a blog. Any ideas?
John Wilber
 
To send a worksheet as the body of a message from an Excel macro, invoke the MailEnvelope object:

Set itm = ActiveSheet.MailEnvelope.Item
With itm
.To = "Address"
.Subject = "Subject"
.Send
End With
 
Back
Top