Thank you for this. So the subject line of the email reads
"Report for Worksheet: Name/Name."

Also I have a question about the:
If olAttach.fileName Like "mavrpt*.*"

for instance if the mavrpt file is called randomly "mavrpt12345678a12.345" will this code above still work?

Thank you for your help