how to send workbook sheet as a sheet (not attachment) via Outlook

[bobm]

Hello,

I need help how to send a worksheet as a sheet so that is displayed in the
body of the email rather than as an attachment. The email program is Outlook.
I've tried to find some code to meet this purpose without success.

I found this site a useful reference but does not allow to send as sheet,
only attachment - http://www.ozgrid.com/VBA/send-email.htm

I also tried Application.SendKeys ("%Fdm") but this only changes the
workbook to an email message. I also want to be able to change the Subject
field and TO field as well each time the sheet is sent (in the vba code).

Any advice is appreciated.

 

[bobm]

i found some code in this site which should meet my needs. it appears to
copy the worksheet as html into the email body.

http://www.rondebruin.nl/mail/folder3/mail4.htm