question

DuncanFisher-1921 avatar image
0 Votes"
DuncanFisher-1921 asked erinding-msft edited

Automated mailing of data from a spreadsheet

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 sheet80165-2021-03-22-110041.png.

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

TIA.



office-vba-dev
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @DuncanFisher-1921
Welcome to Q&A forum.
Based on your description, your issue seems to be more related to macro, as tag "office-excel-itpro" focuses on general issues about Excel clients, I will modify the tag for you.
Thanks for your understanding.

0 Votes 0 ·

0 Answers