When I send a Report email out through VBA, I have figured out how to format the email body and subject, and select the attachment format. How do I set the attachment name?
Currently it saves at the reports base name. I.E. (By Field Report.pdf)
I want it to save as "By Field - " & [Field Name]" - " & Format(Date("dd mmm yyyy"))
So it looks like: By Field - Simulation - 12 Feb 2015.pdf
I understand it would be a save in the temp folder and would be gone as soon as the mail is sent. I can have another button if I want to save locally, or add code to save to the right folder (That's for another thread/day).
Thanks