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 joe.bloggs@abc.com
There are another 12 mobile phone records for manager jack.black@abc.com
What I am after is a macro that the automatically generate a email to joe.bloggs@abc.com with a spreadsheet containing the 16 records belonging to him and another email to jack.black@abc.com with a spreadsheet containing the 12 records belonging to him
Any help with this would be much appreciated