Print Macro to email PDFs of specific pages of a workbook to specific recipients

Hi all,

Right, I've been tasked with finding a way of speeding up our monthly management accounts distribution, and what I need to create are PDFs of specific pages dependent on a changing distribution list of people with constantly changing page requirements.

I've tried various print Macros (unfortunately my knowledge of VB is very limited and a lot of my attempts have been copy & paste & manipulate!) and my latest attempt is attached. However this only creates PDFs based on specific named worksheets ("addtopdf") and is not at all dynamic.

Is there a Macro that would cycle through the rows in named range (DistbnList), creating a new PDF per user from Column A based on the required pages (marked with an X) and creating the email in Outlook ready for sending to the corresponding email address in column B?

The reason I've used a Named Range is hopefully to make it easier to add new recipients as well as new pages but if there's a better way I'm all ears?!

Another cosmetic requirement (although not as crucial as the macro itself) would be that the subject of each email would have the latest month as per the "Cover" worksheet cell C6, as well as the PDF file being saved as the file name + the recipient's name (in this case the first PDF would therefore be "Print Macro v2 A Smith")

Many thanks in advance for any help offered as this is just a little bit over my head!

Mike