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
Bookmarks