attach multiple excel files to same email using send to option
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.
|