We help IT Professionals succeed at work.

Macro to automate attaching specific file to a new email

Kevin Buckland
Last Modified: 2018-02-22
I always have to attach specific 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 the following files:

Attach the file: J:\Portfolio\_Reporting & Operations\Cash Flow Sheets\Morning Cash Recon.xlsx

Thank you.
Watch Question

Top Expert 2016
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
Alexei KuznetsovMicrosoft Outlook MVP

You can do that without macros. The free Add Attachments utility can add files from specified folder in one click on Outlook ribbon.

DISCLAIMER: I recommend this tool because I'm one of the developers, so feel free to ask any further questions.


Worked great, thank you.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions