Create Email messages using VBA within Excel, each email containing some info from the relevant rows for that email recipient

I need this done in 12-24 hours. Purpose: The purpose of our “Exceptions Payroll Report” spreadsheet is to check “timecard-like” values that users entered into our EMR. We are looking for exceptions, such as “overlapping visits”, or “visit-time < 20 minutes”. There 12 exceptions defined (10 ERRs, 2 CHKs.) --------------------------------------------------------------------------------------------------------------------------------------------- Your Task: The worksheet/tab that you need to look at it is “Errors”. The data is already sorted in the right order. All you have to do is this: Using VBA, create VBA code that will generate one HTML email message for each User(User#) showing their daily “time-card” and whatever ERRs or CHKs there are. There are 9 distinct “users(user#)” (column AE) and 111 rows. I am expecting 9 emails, each email having 1 or more HTML tables for that user (a separate HTML table for each distinct date.) To be clear, I (my company) will own this VBA code that you create. This is a “work for hire” project. See two attachments: The source data Excel file, and a Word document that explains the project in more detail.