Hi,
I have managed to find a way of printing all my slicer selections to PDF and store them into a file location using VBA.
Attached is my file.
I also believe there is a way to have a macro that will distribute the email to each advisor as part of the macro. I tried combining an emailing macro with my Print PDF one, but got very stuck.
Does anyone know a way I can combine the two?
Any help would be greatly appreciated.
Thanks
Christof
I have managed to find a way of printing all my slicer selections to PDF and store them into a file location using VBA.
Attached is my file.
I also believe there is a way to have a macro that will distribute the email to each advisor as part of the macro. I tried combining an emailing macro with my Print PDF one, but got very stuck.
Does anyone know a way I can combine the two?
Any help would be greatly appreciated.
Thanks
Christof