You are welcome


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"LoriH" wrote in message ...
That is what I was looking for. I knew I saw it on your site at some point
thank you!!! You are so helpful.

"Ron de Bruin" wrote:

Hi LoriH

Start with this example
http://www.rondebruin.nl/mail/folder2/files.htm

Post back if you need more help

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"LoriH" wrote in message ...
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.