Excel VBA Email with PDF attachments

  • Hi, complete beginner with VBA here. I want to send an email using VBA and attach multiple sheets from the workbook onto the same email, as separate attachments. I found some codes online that attaches a single sheet as a PDF but some of them do not work for me. I'm using Excel-2016. I found one that works but it takes a really long time for the email display to pop up and the code is in no means optimized. Also I'm unable to attach multiple sheets as separate PDFs too.


    Here's my code:


    Strapped of time and also asked this question here:
    http://www.vbaexpress.com/foru…ments&p=381963#post381963