Email Multiple Files to Multiple Email addresses
 

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.

Email Multiple Files to Multiple Email addresses
 

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.

Email Multiple Files to Multiple Email addresses
 

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.

Email Multiple Files to Multiple Email addresses
 

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.