One of our local clients operating in the charity sector needed to be able to print PDF files received by email directly in their warehouse for the pickers to work from and avoid moving around the building to adhere to the COVID-19 policy.

We quickly found that Outlook rules can’t print attachments and there was going to be some VBA involved, the heavy lifting had already be done – see here for original code

www.vboffice.net/en/developers/print-attachments-automatically

That wasn’t compatible with newer versions of VBA and Outlook so we’ve updated the code and it’s running now on Window 10 20H2 with a current Office365 installation.

We have provided the code here as a benefit to the community, it is provided without any warranty or support and is used at your own risk