I have a staff list which, with the help from this site, I have managed to split the file into spearate file based on the Line Manager. I would now like to expand on this so should I add the line manager email address would it be possible to add to the macro to create an email, add text and attach the respective file?
The present VBA code is as follows:
Hope you can help
Please Login or Register to view this content.