Modify email to only send a specific sheet.

Hi I have the following code which make a copy of the workbook and prepares it to send in outlook. All of this works great what I'd like to do it modify it so that it I can send a specific sheet only rather than the whole document, is this possible?

Please Login or Register  to view this content.

Many thanks in advance

Hi thanks for your help, I was hoping I could indicated with sheet(s) by using the sheet names I wanted to attach however if that's too complicated the activesheet would still be very useful.

I tried modifying the code as suggested. It still attaches the whole workbook in the email as before. However it also creates a new excel workbook in the background with a copy of the active sheet.

Cheers

Hi thanks I did notice the wb1, wb2 issue and changed that however I still have the problems above.

Cheers

Edit: I went through is again copying the larger code you provided: it's now copying book1 as an attachment great! however not as an excel document it's html..

Hi it was designed by someone else so I don't really know what's need or not tbh.

Thank perfect, many thanks for that!

No worries, the only I have noticed is that I still get book1 open in the background which I then have to close, is it possible to do it without it opening in the background? Or automatically close book 1 once it’s attched to the email? It’s not a huge issue.

Brilliant, again many thanks!