Split and send Mail

Hi,

I want to split the attached file based on the first column (BU) and send the same to different persons.

Example S01 and S03 to [email protected] and S02 and S04 to 456…@gmailcom like wiles I need to send the Excel file as an attachment to with some standard message in the body of the mail.

PS: in the all excel sheet we need to keep the header i.e rows 1&2.

Regards,
Prabhu