need to save one worksheet into pdf and send via outlook

I have a workbook with multiple worksheets. I need to extract one sheet as a pdf, and attach it to an email. I have found ways to do this by creating a new workbook for the single sheet, renaming and then saving. However, I can't get the code to work for me. I know I am missing something. Please help. If I need to save the new worksheet, I would like it to reference the text in N3.

Side note. I don't need to keep the PDF after it is sent, so if there is a temporary save and then code to delete, please let me know.

Please Login or Register  to view this content.

I was just coming in to delete. I figured out my stupid mistake. However, it showed me a different problem. I have code written for two of the cells (ordinaldate and getdigit) that I will need to copy into the new workbook also to run it properly. Thanks for the attempt anyway!