Macro to send email with multiple attachment

hi every one,

I have the below macro which goes into outlook and works very well, however, it has one limitation that I can only attach on file per email. I was wondering if it is possible to add multiple attachments instead of just one attachment per email. every thing else in the code is fine, just to add additional code to add multiple attachments. for example, in the below macro, outlook picks up information from cell a, cell b and cell c in an excel file containing file name, email address of recipient and file path. Now is it possible that multiple file names can be put in cell A to attach to a single email? or any other way to do this. Because I have list of clients to whom i send multiple files to each of them. The below macro only allows me to send one file in one email and i have to send each client multiple emails for each attachment.

please help me in this as this will really solve my problem if the below code can be modified to include multiple attachments.

thanks and best regards,
CJ


Macro:

Please Login or Register  to view this content.

Hi excelcheck123
Post a sample file of how your data looks including this

Now is it possible that multiple file names can be put in cell A to attach to a single email?

Include your existing code in the sample file. I'd assume we can work through this.