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