I always have to attach two files to multiple emails I send each day. I'd like a macro that I can run after I draft a new email which attaches two files:
- Attach the file: J:\Portfolio\_Reporting & Operations\REPO\RepoTkt.xlsm
- Attach the newest PDF saved to U:\
The U:\ drive is our scan folder on our network. I scan the image from the copier and immediately draft my email -- so the scan I need to attach is always the most recent. The filename is something like DOC_20170329101015.PDF (format is "DOC_" followed by numeric string consisting of the date and time in the format of YYYYMMDDHHMMSS.pdf
Thank you!