I have attached a workbook that has two sales managers who require reports to be sent to them.
The eventual list is 700 managers but I have added two for simplicity.
Each sales manager has booked or managed pdf and .xls
There will always be a booked or managed and there may be a .xls
Once the month is selected i need the code to loop down through all the sales managers and find the attachments in the path, attach them to a new mail and send the attachments with a subject of
I know this is a big ask as it is excel talking to lotus notes, any help would be greatly appreciated!