I have a large excel file with over 15 sheets. Every day another sheet is added. I need to have a way to send multiple sheets from that excel file to all of the upper managment in one email as multiple atachments.

I have tried to create the sheets as a new workbook and then choose file-send to-mail recipient, but it opens up multiple emails. And I am trying to streamline this so I dont have to save each one and attach.

I am using lotus notes for email.

Any help would be appreciated.