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.

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

Details for the initial file is;
30 columns of data
Column to be used to split data is in "H"
The main file is always saved as "OpenTTL_NoText.csv"

An example of the Customers code is GAIM001

Header Row (Row one) to be reproduced on each new file
The new workbook to be saved as the Customers code then todays date

Many thanks
Peter