Create pdf of active sheet and send to email recipient contained in cell use default mail

Hi guys, new to the forum and VBA coding. Already learnt heaps reading through the stickies and previous threads. Been searching for a similar already solved problem but can't find it exactly.

Have been trying to use RDB's coding for these but keep getting compile errors. Saw one of the experienced contributors put this forward for a different problem, is it possible to tweak the below coding to compile a pdf of cells B1:I56 and send to recipient in L4 on button activation using default email program?

Please Login or Register  to view this content.

My main goal is to have the participant value as a listbox with all sections filled out in vlookup with a simple macro button to compile and send through the default mail with a standardised subject and filename.

Really need help with this, happy to contract someone to do the coding if they're interested.

I wondered as much. Thanks Leith.

I'll try the code on my PC @ work and see if I run into difficulties