Emailing A Worksheet

Is There a Way To Email only A Worksheet, not the entire workbook, to a specific email with preset subject, using the default installed email client.


thank you

Probably best to copy the sheet into a new workbook and e-mail that.

You'll need to make a reference to the Outlook object library (assuming that this is your default mail client) and then create an Outlook application object and use this to create the mail message.

Have a look at CreateObject and Application Object in Outlook VBA help.