Email Assigned Seating from Excel

Here is my shot at it.

I truncated your table to just those records for which there is a table assignment for the purposes of testing. BTW: you do not have to add blank lines to at the end of tables. When you enter data on the row below the table, it becomes part of the table and copies down all formulas, formats and validations.

The logic works as follows:

I created two pivot tables. One of them is a list of tables, the other is a list of guests at a specific table. I define the results of these pivot table using named dynamic ranges. These are shown in columns I and J in on the pivot table sheet. You don't need this data and you can delete it. I left it up there to help me remember names as I was programming. Also to show you some of the definitions.

I also filled in the Email Template. Some of this information is provided by formulas and by the VB code. The information you get to change is shaded in green. The Mail Flag can be either TRUE or FALSE. With TRUE, the mail goes out automatically. With FALSE, the mails stack up on the desktop as drafts, so you have a last chance to edit it before clicking on send.

The rest is accomplished with relatively little VB code when I pull in two pieces of "standard" code from my library. These are "reusable."

I could not test this because Malwarebytes is getting in the way.