Prabhu
10-24-2013, 10:49 AM
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
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