Basically looking for code to email the content of sheet3 in PDF format while operating from within sheet1. Content of the email will include cell data from (A1) =(johnDoe@bla.com). Subject line (john Doe) in cell (B1) all the data will come from within sheet1. Plus message (Thank You)