Macro to attach all files in a folder

**Howardc1001** · 11-26-2019, 11:38 AM

I have a macro to create an email and attach a workbook, which works perfectly to attach the active workbbook

However, I need the macro amended so that it attaches all the csv files in the folder "C:\sales JNLS\

Your assistance is most appreciated

Please Login or Register  to view this content.

**JLGWhiz** · 11-26-2019, 04:30 PM

I only tested this for compile errors not for run.

Please Login or Register  to view this content.

**Howardc1001** · 11-26-2019, 10:56 PM

Thanks for the help. I have tested the code and it works perfectly

**JLGWhiz** · 11-27-2019, 09:01 AM

Originally Posted by Howardc1001

Thanks for the help. I have tested the code and it works perfectly

You're welcome,
regards, JLG

Macro to attach all files in a folder

LinkBack

Thread Tools

Rate This Thread

Display

Macro to attach all files in a folder

Re: Macro to attach all files in a folder

Re: Macro to attach all files in a folder

Re: Macro to attach all files in a folder

Thread Information

Users Browsing this Thread

Similar Threads

Attach files created by macro to an email

Outlook macro to attach most recently created file from folder

[SOLVED] Loop Through Folder, Create Emails with Sub Folder Names in Subject, Attach files in sub

Help with macro not working - Pull from fields > attach doc from folder > send email

Excel Email Macro - HELP! - Need to be able to attach two different files

Index Page in Folder for Macro buttons, to Run Multiple Macros on all Files in a Folder

[SOLVED] Macro to loop through workbooks in folder and attach and email using address in closed WB

Bookmarks

Bookmarks

Posting Permissions