In the code, I have 3 attachment Tests in there:

Again I'm new so I apologize if it's bad. No matter what I've tried, the files are never included as an attachment.Īny help would be great, or any alternate suggestions so that everyone can send an email from the excel.īelow is the code I've made. I found a youtube tutorial that helped me, It suggested to store the files in a separate worksheet named 'HiddenSheet' I was able to add a file in cell A1 of the hidden sheet to attach, but I'm having difficulty attaching all 8 files, which are stored in cells A1:A8. Multiple people use this document and will send emails with the 8 attachments, so I need the files in either a centralized location to store the attachments or somewhere we can all access. The attachments are always the same and never change. The problem I have is when I try to Include 8 attachments. I have an excel document that I am using VBA to send out emails based on the data in a worksheet. Hi everyone, I'm going to start off by saying I'm brand new to VBA coding.

Vb coding