New email message with attachment, only for the active worksheets

[Chris Williamson]

Hi guys,
I hope you can help me with my query, I cannot find the right specific vba code that I'm looking for.

What I'm looking to do is from my excel workbook is to create a new email message in outlook, that automatically has an attachment, however, the attachment is not the whole workbook. I'm only looking to have attached three worksheets only.

I'm just looking for a simple vba code, nothing too complicated where I can create the new email message, and the email address and subject lines are automatically completed, I can add my own message body and signature before I hit the send button, but the main thing is that the attachment is a partial workbook, only containing three sheets:-
e.g. worksheets 1, 5 and 6

Please help me, many thanks

Chris