email multiple spreadsheets to multiple people

Does anyone know how to do this?
Open up various excel spreadsheets, copy the contents of one page of each then email to multiple users. I can mostly do this now but the macro stops if the it hits a spreadsheet of a different excel type (which prompts a compatibility message with yes, no or cancel) or a read only prompt comes up because someone already has it open.

Thanks
Beatrice25

Try:

Please Login or Register  to view this content.

thanks I will paste this in and give it a try