Hi All,
I'm using this code that I've come up with on a previous post and it works really very nicely.
https://www.mrexcel.com/forum/excel-questions/1037579-vba-send-email-attachment-question.html
If you take a look at the code, I have the OutMail referencing a cell to gain the information...