Link to home
Start Free TrialLog in
Avatar of Kevin Buckland
Kevin BucklandFlag for United States of America

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:

  • 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!
Avatar of Rgonzo1971

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Kevin Buckland


Works wonderfully! Thank you!!
I posted a follow up that is for a specific file (and doesn't attach the most recent scan):

I also posted another follow up email to get a clean macro that only attaches the latest scan and not the other specific file: