Hi,
I have below code.
I'd like message to say rather than Sales Report the Excel File name.
Can someone help me on what code should i use to to pull the file name and incorporate it to the body of the message.
Thanks
I have below code.
Code:
mItem.Body = "This is an automated message to inform you that " & _
Environ("username") & " has downloaded and is using Sales Report"
I'd like message to say rather than Sales Report the Excel File name.
Can someone help me on what code should i use to to pull the file name and incorporate it to the body of the message.
Thanks