Avatar of Kevin Buckland
Kevin Buckland
Flag 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!
Outlook* Outlook 2013VBA

Avatar of undefined
Last Comment
Kevin Buckland

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rgonzo1971

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Kevin Buckland

ASKER
Works wonderfully! Thank you!!
Kevin Buckland

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
Kevin Buckland

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!
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck