Sending emails from Excel attaching multiple attachments
Posted on 2014-09-30
I have a little doozy that I'm trying to fix asap. Essentially I'm trying to send 2 emails from within a workbook. I've attached the admin page that shows what needs to be sent and to where.
The first email will go to Registrations and it needs to have up to 3 attachments (PDFcatch, PDFprocess & PDFreport = only if Result is Required) along with the text in the email body at the base of the page. It needs to be sent to the TO & CC address.
The second email is called Submission and it contains an excel file along with the text in the email body at the base of the page. It only needs to be sent to the TO address.
I've managed to create a few modules that send the workbook but I now want to attach the files that are referred to in the cells (named ranges).
I'd love some help...
I'm assuming it can be done.