Email Multiple Files to Multiple Email addresses


L

LoriH

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.
 
Ad

Advertisements

L

LoriH

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

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top