sending email from outlook using vba excel

Thanks for the great posts guys, trying to do something similar using RDB's coding but it keeps coming up with compile errors.

Is it possible to tweak the basic code to compile a pdf of cells B1:I56 and send to recipient in L4 on button activation using default email program?

Having a lot of trouble combining the VBA sections and every time I get compile errors.

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.

I should also note, I'm editing this in Excel for Mac 2011 and want it to be compatible with older versions of excel on PC's