Macro to split excel file into seperate files and then email

[Prabhu]

I have to split an excel file into seperate files using particular customer
codes and then email these directly to a particaular email account depending
on the customer code(column A).

Is it possible to automate the cutting of the original file and then (maybe)
email these directly?

Header Row (Row 1& 2) to be reproduced on each new file
The new workbook to be saved as the Customers code then todays date and no need to keep backup after sending mail.

Regards,

Prabhu