VBA code to Email excel sheets as an attachment to different people

[seeker123]

Hi everyone

I have an excel file with several sheets and i want to send every sheet as an attachment to certain people in to and cc in outlook .recipients are different for every sheet and I want to add subject and body of email too.( I want email to be ready with To CC Subject and body and just press send .) can you help me?

thanks a lot in advance.