Create SpreadsheetEmailer

This script was written for a spreadsheet intended to coordinate office moves. The spreadsheet has two sheets: The first lists details for each individual's current and new offices and when they would be moving. The second lists the departments and whether all of the information has been put in for that department. The script sends an email to technicians when all of the information has been put in for a particular department, triggered by the administrative assistant putting "yes" in the second sheet.

Note: The for loop begins at i=4 because the second sheet has three rows of header information.