I am trying to send an Outlook email from Excel VBA. I am attaching a signature file.

I am trying to send an Outlook email from Excel VBA. I am attaching a signature file.

I am trying to send an Outlook email from Excel VBA. I am attaching a signature file.

I open a UserForm VidEmailForm which gets variables ccPeeps, VidEmailSubject, and VidEmailLink.

I am using the code below to automatically generate an email and embed one pivot table and two tables. This data comes from three separate Power Queries (one original and two duplicates) with slightly different custom columns. This code works perfectly when adding the pivot and one of the two tables. Later, I realized I needed to add a third table and thought it would be easy to modify this code to include, but for some reason, it’s unable to contain the third table, ‘Defect_Log_Open_2’. I decided to remove the original pivot ‘PivotTable2’ and table ‘Defect_Log_Table’ and try to get the newly added table ‘Defect_Log_Open_2’ image to load into the email by itself. The image of that table appeared briefly, like a flicker, and then disappeared. I am at a loss, and frankly, at my wit’s ends why this is occurring, so I thought a fresh pair of eyes could see something I am missing. Thanks for your input.

I am using the code below to automatically generate an email and embed one pivot table and two tables. This data comes from three separate Power Queries (one original and two duplicates) with slightly different custom columns. This code works perfectly when adding the pivot and one of the two tables. Later, I realized I needed to add a third table and thought it would be easy to modify this code to include, but for some reason, it’s unable to contain the third table, ‘Defect_Log_Open_2’. I decided to remove the original pivot ‘PivotTable2’ and table ‘Defect_Log_Table’ and try to get the newly added table ‘Defect_Log_Open_2’ image to load into the email by itself. The image of that table appeared briefly, like a flicker, and then disappeared. I am at a loss, and frankly, at my wit’s ends why this is occurring, so I thought a fresh pair of eyes could see something I am missing. Thanks for your input.

I am using the code below to automatically generate an email and embed one pivot table and two tables. This data comes from three separate Power Queries (one original and two duplicates) with slightly different custom columns. This code works perfectly when adding the pivot and one of the two tables. Later, I realized I needed to add a third table and thought it would be easy to modify this code to include, but for some reason, it’s unable to contain the third table, ‘Defect_Log_Open_2’. I decided to remove the original pivot ‘PivotTable2’ and table ‘Defect_Log_Table’ and try to get the newly added table ‘Defect_Log_Open_2’ image to load into the email by itself. The image of that table appeared briefly, like a flicker, and then disappeared. I am at a loss, and frankly, at my wit’s ends why this is occurring, so I thought a fresh pair of eyes could see something I am missing. Thanks for your input.