Automated mailing of data from a spreadsheet

Question

I have a report in Excel that groups data by customer in rows, each report (monthly) has a different number of transactions and therefore rows and what I hope to do is email the data per customer to that customer.

The format of the report is as attached with each discrete data set defined by a cell in Column A which has an account code, a comma and then the company name. The following immediately rows have the transactional details which I need to email, the email address for each account would be held in a separate sheet as attached.

I am seeking to build a macro driven sheet that this data would be pasted into with simple controls that send each customer's subset of data to the appropriate address but am unsure of the best methodology to do this. The nuisance is that there are about 60-70 customers so am seeking the lowest manual input and computational load for the finished sheet.

If anyone has suggestions as to how I should approach this I would much appreciate it.

TIA.