I can do the job! Will make excel with macros which prints pdf and sends via your outlook. Aditionally we could include automatic pivto table filter changing so you just right down a list of costumers and the macro sweeps through it, update pivot table, prints to pdf, sends mail, and log results for operation.
I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Office and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project,MS Visio, Autocad, pdf, CorelDraw, PhotoShop, etc.). Also on web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6, AI (neural networks, genetic algorithms, optimized search, etc).