Vba to email multiple attachments but do nothing if no attachments AND use SendUsingAccount

  • Hello, All,

    Have adapted a few sample codes that I have found (below) to try and automate an email process. I need to use a specific send account, attach one or two PDF files in specified folder with file names that do not change and also check if there are not any attachments, then send nothing. This is what I have modified below that will work-for one attachment only. Note: I found several code samples for SendUsingAccount but this is the only one that would work with an attachment.

    I have tried a number of different methods but cannot get it to work. I'd appreciate any suggestions.

    Thank you,


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!