• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro to send PDFs in Email?

Christof

Member
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
 

Attachments

Christof

Member
Is there then a possibility of the pdf selection and email address being selected and "Mail" button pressed in a Slicer loop through? Or is that just dreaming?
 
Top