Batch email in excel 2016 requires a few special considerations.  We have to download a specific applescript file and put it in a folder that Excel can read it from. So first:

And put this in the location: 

Library/Application Scripts/

This is what is vital to making your batch email function work!  To access your library folder if it currently does not show, click here for instructions.