Hi

Every month we produce accounts for all the cost centres and I have a macro that emails each tab in the workbook to the specific email address on the sheet, 1 per cost centre.

Now there is going to be 2 sheets (one data and the other graphs) for 1 cost centre. While my macro will still work, it will sent 2 emails to each cost centre. But people higher up don't want that, they want both data and graph sheets to be attached on 1 email.

They are wanting this done in the next few days. I have no idea how to do this and really don't want to go back to manually as there are over 200 cost centres!

The code I have for sending the individual tabs out is:

HTML Code: 
Any help on this will be appreciated

Thank You