I'm trying to figure out how to make a macro that'll help me send numerous emails with excels files attached through a macro.
The general idea is:
I have a list of recipients in excel and a folder of reports that has to be sent to the respective recipients of the cost centers. Example:
Name of recipient: C2 to C300
CC: D2 to D300
The file that recipient should get (name of the file in the folder): A2 to A300
A folder of 300 files that has to be sent to the right recipient dependent on the above information.
How could I go about this problem?
Thanks in advance!