Adjust email macro to send only select files in a folder rather than all ref'ed in a range

Hi everyone,

I have the following code I use to email attachments from a folder location to multiple recipients listed on an excel worksheet:

Please Login or Register  to view this content.

Right now, the code reads the email addresses and uses the folder link text in columns F and G to file files to email. Each row in columns F and G correspond to an email recipient in the same rows in column D.

What I'd like to do is amend the code so that only cells selected in column B will result in the files location text found in columns F and G to be sent. So for example, if I select cells B2, B4 and B24, only the file location text found cells F2, F4, and F24 will be used to find the attachments and send the emails. Any other file locations in columns F and G that are not in those three rows will be ignored.

Any ideas?

Thanks!!

Hey Alpha,

I'm trying to email only those attachments that I've selected in column B. So right now, the macro will send an email with attachment to every recipient that has a folder address in column F:G. I'm trying to make it so that those selected in column B will have an email sent with appropriate attachment in the same row.