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/com.microsoft.Excel/
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.