Automatic Email and Attachement

Hi all,

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:

Please Login or Register  to view this content.

Hope you can help

Regards

Phil