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
State
Service Number
Service Name
Calls & Usage Charges
Other Charges or Credits
Service Access Charges
Total Charges Inc. GST
Billing Month
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 [email protected]
There are another 12 mobile phone records for manager [email protected]
What I am after is a macro that the automatically generate a email to [email protected] with a spreadsheet containing the 16 records belonging to him and another email to [email protected] with a spreadsheet containing the 12 records belonging to him
Any help with this would be much appreciated