I am fairly new at creating macros but have learned so much from reading the
posts on here.

I have 400 workbooks and I need to send three to five different workbooks to
each of my reps email address every month. All workbooks are saved in the
same folder and I can use a looping macro to send them out. The names of the
files I need to send to each email address are the same every month. I have
the email addresses in a workbook and I can use that as the basis for the
macro. I need a macro that tells Excel to loop through a folder looking for
specific files and email them only to the email address in a collumn of that
same row. I tried editing some of Ron De Bruins code but am lost. Thank
you in advance for any help provided.