I have now solved the issue. Simply using the spreadsheet directly on my company network with no changes to the code solved the issue and emails sent fine to both internal and external emails with no run time errors. The runtime error must have just been due to the company server blocking my home IP address or something.

HUGE thank you to judgeh59 for the code!!!