asked on Macro to automate attaching two files to a new email
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:
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!
- Attach the file: J:\Portfolio\_Reporting & Operations\REPO\RepoTkt.xl
sm - 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!
Outlook* Outlook 2013VBA
Last Comment
Kevin Buckland
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Works wonderfully! Thank you!!
ASKER
I posted a follow up that is for a specific file (and doesn't attach the most recent scan):
https://www.experts-exchange.com/questions/29012843/Macro-to-automate-attaching-specific-file-to-a-new-email.html
Thanks
https://www.experts-exchange.com/questions/29012843/Macro-to-automate-attaching-specific-file-to-a-new-email.html
Thanks
ASKER
I also posted another follow up email to get a clean macro that only attaches the latest scan and not the other specific file:
https://www.experts-exchange.com/questions/29012846/Macro-to-automate-attaching-the-newest-scan-to-a-new-email.html
Thanks!
https://www.experts-exchange.com/questions/29012846/Macro-to-automate-attaching-the-newest-scan-to-a-new-email.html
Thanks!