Have approx 2000 Mobile Phone charge records each month. Each Mobile record is assigned a reporting Managers email address.
Each record includes the following data
Calls & Usage Charges
Other Charges or Credits
Service Access Charges
Total Charges Inc. GST
Reporting Line Manager
Name Manager Email
I want to be able to do the following with the monthly data:
For each Managers email id, generate a email containing all the mobile phone charges which belong to the managers email as a spreadsheet.
Also want to be able to include a standard email message in the body of the email.
I have attached a sample file of data.
In the sample file, there are 16 mobile phone records which belong to manager email firstname.lastname@example.org
There are another 12 mobile phone records for manager email@example.com
What I am after is a macro that the automatically generate a email to firstname.lastname@example.org with a spreadsheet containing the 16 records belonging to him and another email to email@example.com with a spreadsheet containing the 12 records belonging to him
Any help with this would be much appreciated