Sending e-mail - of single tab in a work book

[bobski2022]

Hi

I am running a report out into excel for a division of the business (from excelerator on our accounting software), but it also breaks out the areas on separate tabs - so I am hoping to be able to e-mail the director the whole file (which I can do), and then to e-mail the sub-managers with their individual tab/sheet using a macro.

I managed to pick up a macro from youtube picking how to send the whole workbook but not individual sheets and my feeble attempt at amending it falls foul of the debugger - please help.

 

[mumps]

This could be done by saving each individual sheet as a separate file and then adding the file as an attachment or by adding the contents of each sheet to the body of the email. It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach screenshots (not pictures) of at least 2 individual sheets. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). It would also be helpful to know if the email addresses of the recipients are included in the sheets and also what the subject line would be.