Sending a sheet in the body of an e-mail

[myfe]

Hi,</SPAN>

I have this code that send’s the whole work book as an attachment through web-mail (not outlook).</SPAN>

Sub SendIt()
Application.Dialogs(xlDialogSendMail).Show arg1:=XXX@XXX.com, _
arg2:="This goes in the subject line"
End Sub

Can anyone tell me how to make a code that:</SPAN>
1-Sends the e-mail through the web-mail the same way in my mentioned code (not through outlook).</SPAN>
2- Reads the e-mails I want to send to from a cell : TO , CC & Bcc.
or from a text box if I am using userform.
3-Sends only one sheet in the body of the e-mail (not as attachment) Like copy the sheet and past it in the body of the e-mail.


Any help is really appreciated thank you all.</SPAN>

 

[Domski]

Have a look here: http://www.rondebruin.nl/sendmail.htm

Dom