Excel, VBA, sending an email with muliple attachments
Posted on 2013-10-29
I have code for a macro that allows me to send an email to receipients with one or two attachments. What I need is code that will attach multiple files, say up to 7, that are in a specific folder. All of the files have a .csv extension but the actual filename will change. The number of files in the folder could be anything from 1 to 7.
Is there code to attach multiple files to an email without specifying each filename? The alternative, would be code that prompted the sender to choose the files to send.
Any assistance would be appreciated.