VBA scrip to filter spreadsheet, save filtered data and email as attachment

[Djxela]

Hi all,

I have an excel spreadsheet with sales data, column range A - AQ

I need a macro that will automatically filter the data, save spreadsheet and send 3 types of email
1- to the sales person - their unique id is in column AB, email in column AC and name in column AD
2- the sales person Manager - their unique id is in column AG, email in column AN and name in column AJ
3- the department Manager - their unique id is in column AO, email in column AP and name in column AQ

Each email Subject should have: "Sales data for" today's date

Body of email "" for each type of email should be customized
1- Dear Column AD, find attached your sales data
2- Dear Column AJ, find attached your employees sales data
3- Dear Column AQ, find attached your department sales data

[Keebellah]

Hi, welcome to the forum.
It can de done and there are several posts with a similar request, you'll have to do an advanced search but I suggest you attach a sample file with the lay-out and some non-sensitive data en fake email addresses.
Will make it easier to help than giving you a solution and you having to modify it again to suit your needs

[Djxela]

Hi Keebellah,
Thanks for the feedback. I have attached a small sample.
I will try to try you suggestion of advanced search.

[Keebellah]

Okay, I'll see if I can help, do you have any experience with macros and VBA code?