VBA for sending workbook via Outlook

[Tod]

I can select File>Send To>Mail Recipient and it will allow me to send a
worksheet as if it were the body of the message. How do I do that with
VBA from within the workbook?

tod

 

[Tom Ogilvy]

See Ron de Bruin's site for sample code:

http://www.rondebruin.nl/sendmail.htm