Email Macro to attach a non active worksheet to outlook email

hi all

i am after a macro or advice on attaching a worksheet to a email (outlook). the way the worksheet works is that it will not be the active sheet that needs to be attached to the email.

can anyone help please

mick

Are you saying that you are in a workbook with only two worksheets and you want to attach the second, non-active, worksheet to an email and do not want the recipients to see the currently active worksheet? Or are you saying that you want to attach a workbook that is not even open?

yes mate

workbook with two sheets, i want to attach the non active one only and not the active one. so basically create a macro that takes second sheet,makes a new workbook and emails it to

mick

I'm not sure how to mail just one worksheet without creating a new workbook. This macro will Save the current workbook in whatever location you specify with a new name. Change the file path and name to whatever you want. I like to keep the same file name so that it saves over itself every time I use the macro so that that I don't have hundreds of saved files. It's up to you if you want to keep backups though. The macro then deletes the active worksheet, leaving only the second worksheet. It will then attach itself to a new email for you!

Please Login or Register  to view this content.