.
First question ... because everyone uses OUTLOOK and presumably EXCEL is available to them ... wouldn't it be easier to simply
create a mass email in OUTLOOK and attach the updated ABSENT LIST ? Why the extra step/work to create everything in EXCEL ?

But .. to answer your question ... yes, EXCEL can do that.