Macro to split excel file into seperate files and then email
 

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

Macro to split excel file into seperate files and then email
 

I'd start with Ron de Bruin's site:
http://www.rondebruin.nl/tips.htm

He has lots of sample code to do this kind of thing.

He also has an addin that may help you:
http://www.rondebruin.nl/easyfilter.htm

And if you're interested in emailing from excel, refer to Ron's site, too:
http://www.rondebruin.nl/sendmail.htm



LITTLE PETE wrote:

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

--

Dave Peterson