I see your posts and wondering if you can help with a simple VBA code. I have the code to send the email from excel and include as attachment, but I want to change the attachment name to be .fullname plus add a cell value to the end of the full name.
This is what I have.
.attachments.Add ActiveWorkbook.FullName & "_" & Range("k1").Value & ".xlsm"
With .fullname by itself it works fine. when I add anything else to try to get the name to change, no attachment.
This is what I have.
.attachments.Add ActiveWorkbook.FullName & "_" & Range("k1").Value & ".xlsm"
With .fullname by itself it works fine. when I add anything else to try to get the name to change, no attachment.