Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Macro how to create email link for the email addresses in aRange or Selection | Excel Worksheet Functions | |||
How do you attach multiple email addresses within different cells | Excel Discussion (Misc queries) | |||
How do I count unique email addresses across multiple worksheets? | Excel Discussion (Misc queries) | |||
Macro to send email to multiple addresses | Excel Worksheet Functions | |||
Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) |